Equijoins or Inner Join
SQL >SELECT Table_A.letter, Table_B.letter
2 FROM Table_A, Table_B
3 WHERE Table_A.letter = Table_B.letter;
LETTER LETTER
---------- ----------
A A
SQL >SELECT Table_A.letter, Table_B.letter
2 FROM Table_A INNER JOIN Table_B
3 ON Table_A.letter = Table_B.letter;
LETTER LETTER
---------- ----------
A A
Self Joins
SQL >SELECT A1.letter, A2.letter
2 FROM Table_A A1, Table_A A2
3 WHERE A1.letter = A2.letter;
LETTER LETTER
---------- ----------
A A
B B
SQL >SELECT A1.letter, A2.letter
2 FROM Table_A A1 INNER JOIN Table_A A2
3 ON A1.letter = A2.letter;
LETTER LETTER
---------- ----------
A A
B B
Left Outer Joins
SQL >SELECT Table_A.letter, Table_B.letter
2 FROM Table_A, Table_B
3 WHERE Table_A.letter = Table_B.letter(+);
LETTER LETTER
---------- ----------
A A
B
SQL >SELECT Table_A.letter, Table_B.letter
2 FROM Table_A LEFT OUTER JOIN Table_B
3 ON Table_A.letter = Table_B.letter;
LETTER LETTER
---------- ----------
A A
B
Right Outer Joins
SQL >SELECT Table_A.letter, Table_B.letter
2 FROM Table_A, Table_B
3 WHERE Table_A.letter(+) = Table_B.letter;
LETTER LETTER
---------- ----------
A A
C
SQL >SELECT Table_A.letter, Table_B.letter
2 FROM Table_A RIGHT OUTER JOIN Table_B
3 ON Table_A.letter = Table_B.letter;
LETTER LETTER
---------- ----------
A A
C
Full Outer Joins
SQL >SELECT Table_A.letter, Table_B.letter
2 FROM Table_A, Table_B
3 WHERE Table_A.letter = Table_B.letter(+)
4 UNION
5 SELECT Table_A.letter, Table_B.letter
6 FROM Table_A, Table_B
7 WHERE Table_A.letter(+) = Table_B.letter;
LETTER LETTER
---------- ----------
A A
B
C
SQL >SELECT Table_A.letter, Table_B.letter
2 FROM Table_A FULL OUTER JOIN Table_B
3 ON Table_A.letter = Table_B.letter;
LETTER LETTER
---------- ----------
A A
B
C
Cartesian Products
SQL >SELECT Table_A.letter, Table_B.letter
2 FROM Table_A, Table_B;
LETTER LETTER
---------- ----------
A A
A C
B A
B C
SQL >SELECT Table_A.letter, Table_B.letter
2 FROM Table_A CROSS JOIN Table_B;
LETTER LETTER
---------- ----------
A A
A C
B A
B C
Reference Document dbasupport.com
