Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@Macagare

Macagare/compareTables.sql

Created April 3, 2017 11:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Macagare/124031b95bd4d836135455862499f3d4 to your computer and use it in GitHub Desktop.
Save Macagare/124031b95bd4d836135455862499f3d4 to your computer and use it in GitHub Desktop.
Download ZIP
compare two table for missing ids
Raw
compareTables.sql
SELECT table1.ID
FROM table1
LEFT OUTER JOIN table2 ON table1.ID = table2.ID
WHERE table2.ID IS NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment