How would you do this T-SQL statement to QlikView?
LEFT JOIN B
I am particularly after how to display A.Key1 and B.Key1 which I can do in T- SQL
use alias in sql query itself.
load * resident A where A.Key1=B.Key1;
drop table A;
It seems like it works as an inner join and not a left join.
It doesn'y show all the records from table A.
Retrieving data ...