Join Problem

[k_burata]

Hi all,

How would you do this T-SQL statement to QlikView?

SELECT

     A.Key1,

     B.Key1,

     A.Data1,

     A.Data2,

     B.Data3

FROM A

LEFT JOIN B

ON A.Key1=B.Key1

I am particularly after how to display A.Key1 and B.Key1 which I can do in T- SQL

Thanks

[mightyqlikers]

hi Kim,

use alias in sql query itself.

Regards

Sam     

[sasiparupudi1]

qualify *;

A:

SQL SELECT

     Key1,

     Data1,

     Data2

FROM A;

LEFT JOIN(A)

B:

SQL SELECT

     Key1,

     Data3

FROM B;

noconcatenate

FINAL:

load * resident A where A.Key1=B.Key1;

drop table A;

[k_burata]

Hi Sasidhar,

It seems like it works as an inner join and not a left join.

It doesn'y show all the records from  table A.

Regards,

[sasiparupudi1 · Accepted solution]

then try

A:

SQL SELECT

     Key1,

     Data1,

     Data2

FROM A;

LEFT JOIN(A)

B:

SQL SELECT

     Key1,

     Data3

FROM B;

[k_burata]

Thanks Sasidhar.