Set A is squares and Set B is red shapes. For each one of the joins above, describe what will be shown. For example: Join 1 will show circles that are also purple. 1. FROM TableA ALEFT JOIN TableB...

Set A is squares and Set B is red shapes.

For each one of the joins above, describe what will be shown.For example: Join 1 will show circles that are also purple.

Extracted text: SQL JOINS A |B A B SELECT 1. FROM TableA A LEFT JOIN TableB B ON A.Key = B.Key SELECT 2. FROM TableA A RIGHT JOIN TableB B ON A.Key = B.Key A В A В SELECT A 7. FROM TablcA A INNER JOIN TableB B ON A.Key = B.Key SELECT 3 FROM TableA A LEFT JOIN TableB B ON A.Key = B.Key WHERE B.Key IS NULL SELECT 4. FROM TableA A RIGHT JOIN TableB B ON A.Key = B.Key WHERE A.Key IS NULL A A SELECT 5. FROM TableA A FULL OUTER JOIN TableB B ON A.Key = B.Key SELECT FROM TableA A FULL OUTER JOIN TableB B 6. ON A.Key = B.Key WHERE A.Key IS NULL OR B.Key IS NULL OCL Moffatt, 2008