Skip to content

Instantly share code, notes, and snippets.

@afcotroneo
Created May 26, 2021 14:15
Show Gist options
  • Select an option

  • Save afcotroneo/821b8cf1acbbbc7488eeb3d0e598b149 to your computer and use it in GitHub Desktop.

Select an option

Save afcotroneo/821b8cf1acbbbc7488eeb3d0e598b149 to your computer and use it in GitHub Desktop.
SELECT count(*) FROM t1 INNER JOIN t2 ON t1.a = t2.b;
for t1_row in t1.rows:
for t2_row in t2.rows:
if (t1_row.a = t2_row.a):
output_match()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment