Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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"
hiii
in qlikview
putting either join or outer join between two table is same, so don't be confused
see the attached file