1. SELECT FROM TableA A INNER JOIN TableB B ON A.key=B.key
2. SELECT FROM TableA A RIGHT JOIN TableB B ON A.key=B.key
3. SELECT FROM TableA A RIGHT JOIN TableB B ON A.key=B.key WHERE A.key IS NULL
4. SELECT FROM TableA A LEFT JOIN TableB B ON A.key=B.key
5. SELECT FROM TableA A RIGHT JOIN TableB B ON A.key=B.key WHERE B.key IS NULL
6. SELECT FROM TableA A FULL OUTER JOIN TableB B ON A.key=B.key
7. SELECT FROM TableA A FULL OUTER JOIN TableB B ON A.key=B.key WHERE A.key IS NULL OR B.key IS NULL