Skip to content

Instantly share code, notes, and snippets.

@seagoj

seagoj/join.sql

Created April 28, 2021 04:08
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 seagoj/e5edcd545dc1f8951cc1883c7fb53535 to your computer and use it in GitHub Desktop.
Save seagoj/e5edcd545dc1f8951cc1883c7fb53535 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
join.sql
-- matches in A and B
SELECT count(A.*)
FROM A
JOIN B ON DATE(A.date) = DATE(B.date), A.id = B.id, A.phone_number = B.phone_number;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment