1. SELECT FROM TableA A INNER JOIN TableB B ON A.key=B.key2. 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 NULL4. 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 NULL6. SELECT FROM TableA A FULL OUTER JOIN TableB B ON A.key=B.key7. SELECT FROM TableA A FULL OUTER JOIN TableB B ON A.key=B.key WHERE A.key IS NULL OR B.key IS NULL

