JOIN tables infinite loop

[#1]

Hello

Is it possible with Qlikview to join two table and take all field from table 1 and some fields from table  2

It sound simple, very easy to do in SQL but when I try in Qlikview it always fall into an infinite loop and I have to restart Qlikview

Im new to Qlikview but there are a lot of think much more easier to do in SQL rather than in Qlikview

Here is my syntax

join(tmpqa)

*,

promotest as promox

resident allitems;

So I'm expecting to add the field promox existing in the table allitems into the table tmpqa

Tho only common field into the two table is a field 'itemid' (numeric)

Is there something wrong in my syntax ?

Thank for your help

[#2]

Hello

I don't know why the join is not working but a map do the job

It sounds a bit tricky but it works

So

- first I create a map extracting ItemID and promotest from my table allitems

- thhen I apply the map on my tmpqa table