devxlogo

SQL JOINs

SQL JOINs

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

devx-admin

Share the Post: