birchestx/find_unknowns

Last active August 29, 2015 14:05

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

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/birchestx/f5b906adf5d47fda3323.js"></script>
Save birchestx/f5b906adf5d47fda3323 to your computer and use it in GitHub Desktop.

Download ZIP

find where database consistencies join table

Raw

find_unknowns

	SELECT c.ID, c.user_id
	FROM carriers c
	LEFT JOIN users u ON c.user_id = u.ID
	WHERE u.ID IS NULL

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