Join problem

[#1]

hi all

i have two tables - one table contains the numbers 1 to 10, the other table contains the numbers 1 to 15. I am looking for a way to join those two table with the resulttable having the numbers 11 to 15.

Can someone help me out here ?

Thanks,

K

[its_anandrjs]

Hi,

Join tables with join command like

Table1:

Load

*,

NumberField

From data;

Join

Load

*,

NumberField

From data;

Let me know about this

Rgds

Anand

[its_anandrjs]

Hi,

If the number field name should be same in the both tables so there is no need to join then in qlikview it will automatically joins.

But otherwise you need to join them by prefix Join, innerjoin, Letjoin, Rightjoin.

Rgds

Anand