Skip to content

Instantly share code, notes, and snippets.

@phuzion
Created December 16, 2011 17:35
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 phuzion/1487038 to your computer and use it in GitHub Desktop.
Save phuzion/1487038 to your computer and use it in GitHub Desktop.
table_a
col_a col_b
a foo
b bar
c baz
d bam
e meep
f moop
g pluh
table_b
col_c col_d
g 22
e 1
j 5
n 4
q 8
a 43
y 23
f 66
x 54
e 12
u 21
n 32
g 4
f 1
How would I find all rows in table_b that do not have a match between table_a.col_a and table_b.col_c?
In other words, how do I get it to return:
table_b
col_c col_d
e 1
j 5
n 4
q 8
y 23
x 54
u 21
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment