SQL JOINs

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