Skip to content

Instantly share code, notes, and snippets.

@AayushSameerShah

AayushSameerShah/SQL_exclude_intersection.sql

Created December 6, 2021 17:14
Show Gist options
  • Save AayushSameerShah/7bd32e844a68e06e890098d1e386fad6 to your computer and use it in GitHub Desktop.
Save AayushSameerShah/7bd32e844a68e06e890098d1e386fad6 to your computer and use it in GitHub Desktop.
Download ZIP
The SQL statement to exclude the intersection of full outer join
Raw
SQL_exclude_intersection.sql
SELECT *
FROM table_A
FULL OUTER JOIN table_B
ON table_A.col = table_B.col
WHERE table_A.col IS null
OR table_B.col IS null
@AayushSameerShah
Copy link
Author

Exact opposite of innter join!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment