Skip to content

Instantly share code, notes, and snippets.

@latompa
Created November 12, 2009 23:37
Show Gist options
  • Save latompa/233430 to your computer and use it in GitHub Desktop.
Save latompa/233430 to your computer and use it in GitHub Desktop.
customer_addresses
cust_id, address_id, preferred
--------------------------------
1 1 true
1 2 false
2 3 true
3 4 false
find customers that only have preferred=false addresses
in this case, cust_id 3 (but not 1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment