Macagare/compareTables.sql

Created April 3, 2017 11:19

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Macagare/124031b95bd4d836135455862499f3d4.js"></script>
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