INNER JOIN A_PK A_Value B_Value B_PK ----------- ---------- ---------- ----------- 1 FOX TROT 1 2 COP CAR 2 3 TAXI CAB 3 6 WASHINGTON MONUMENT 6 7 DELL PC 7 (5 row(s) affected) LEFT JOIN A_PK A_Value B_Value B_PK ----------- ---------- ---------- ----------- 1 FOX TROT 1 2 COP CAR 2 3 TAXI CAB 3 4 LINCOLN NULL NULL 5 ARIZONA NULL NULL 6 WASHINGTON MONUMENT 6 7 DELL PC 7 10 LUCENT NULL NULL (8 row(s) affected) RIGHT JOIN A_PK A_Value B_Value B_PK ----------- ---------- ---------- ----------- 1 FOX TROT 1 2 COP CAR 2 3 TAXI CAB 3 6 WASHINGTON MONUMENT 6 7 DELL PC 7 NULL NULL MICROSOFT 8 NULL NULL APPLE 9 NULL NULL SCOTCH 11 (8 row(s) affected) OUTER JOIN A_PK A_Value B_Value B_PK ----------- ---------- ---------- ----------- 1 FOX TROT 1 2 COP CAR 2 3 TAXI CAB 3 4 LINCOLN NULL NULL 5 ARIZONA NULL NULL 6 WASHINGTON MONUMENT 6 7 DELL PC 7 10 LUCENT NULL NULL NULL NULL MICROSOFT 8 NULL NULL APPLE 9 NULL NULL SCOTCH 11 (11 row(s) affected) LEFT JOIN EXCLUDING INNER JOIN A_PK A_Value B_Value B_PK ----------- ---------- ---------- ----------- 4 LINCOLN NULL NULL 5 ARIZONA NULL NULL 10 LUCENT NULL NULL (3 row(s) affected) RIGHT JOIN EXCLUDING INNER JOIN A_PK A_Value B_Value B_PK ----------- ---------- ---------- ----------- NULL NULL MICROSOFT 8 NULL NULL APPLE 9 NULL NULL SCOTCH 11 (3 row(s) affected) OUTER JOIN EXCLUDING INNER JOIN OR LEFT & RIGHT JOINS EXCLUDING INNER JOIN A_PK A_Value B_Value B_PK ----------- ---------- ---------- ----------- 4 LINCOLN NULL NULL 5 ARIZONA NULL NULL 10 LUCENT NULL NULL NULL NULL MICROSOFT 8 NULL NULL APPLE 9 NULL NULL SCOTCH 11 (6 row(s) affected)