Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Outer join and Association question

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!

2 Replies
Not applicable
Author

Table1

A

B

1

aa

2

cc

3

ee

Table2

A

C

1

xx

4

yy

select * from table1;

join

select * from table2;

OR

select * from table1;

outer join

select * from table2;

Joined table

A

B

C

1

aa

xx

2

cc

-

3

ee

-

4

-

yy

note-  join and outer join are the same

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

er_mohit
Master II
Master II

hiii

in qlikview

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

see the attached file