topic Re: Outer join and Association question in QlikView

Outer join and Association question

Mon, 11 Feb 2013 20:35:40 GMT

Hi ! I'm not sure about the meaning of the following sentence in Reference Manual Book I Page 472. Can you help me?

"An outer join in SQL is usually a one way projection of one table on another"

Thanks!

Tue, 12 Feb 2013 12:46:05 GMT

select * from table1;

join

select * from table2;

select * from table1;

outer join

select * from table2;

note- join and outer join are the same

"here we see the projection of one table on another"

er_mohit — Tue, 12 Feb 2013 12:48:27 GMT

hiii

in qlikview

putting either join or outer join between two table is same, so don't be confused

see the attached file