Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
How would you do this T-SQL statement to QlikView?
SELECT
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
then try
A:
SQL SELECT
Key1,
Data1,
Data2
FROM A;
LEFT JOIN(A)
B:
SQL SELECT
Key1,
Data3
FROM B;
hi Kim,
use alias in sql query itself.
Regards
Sam
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;
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,
then try
A:
SQL SELECT
Key1,
Data1,
Data2
FROM A;
LEFT JOIN(A)
B:
SQL SELECT
Key1,
Data3
FROM B;
Thanks Sasidhar.