Skip to content

Instantly share code, notes, and snippets.

@wwahammy

wwahammy/find_differences.sql

Created April 15, 2020 17:40
Show Gist options
  • Save wwahammy/b1c24058ff83fd204ed560f668cbddd3 to your computer and use it in GitHub Desktop.
Save wwahammy/b1c24058ff83fd204ed560f668cbddd3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
find_differences.sql
((SELECT * FROM payments LEFT OUTER JOIN supporters ON supporters.id = payments.supporter_id)
EXCEPT ALL (SELECT * FROM payments INNER JOIN supporters ON supporters.id = payments.supporter_id))
UNION ALL
((SELECT * FROM payments INNER JOIN supporters ON supporters.id = payments.supporter_id)
EXCEPT ALL (SELECT * FROM payments LEFT OUTER JOIN supporters ON supporters.id = payments.supporter_id))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment