Skip to content

Instantly share code, notes, and snippets.

@saulhappy
Created March 19, 2018 15:20
Show Gist options
  • Save saulhappy/ce6a67df327f92f21679ab33f1d5e6ed to your computer and use it in GitHub Desktop.
Save saulhappy/ce6a67df327f92f21679ab33f1d5e6ed to your computer and use it in GitHub Desktop.
current san antonio customers
SELECT account_id, account_name, first_name, last_name, address_line1,address_line2,address_city,address_state,address_zip
FROM accounts_account a
INNER JOIN accounts_contact ac USING (account_id)
WHERE a.active IS TRUE
AND address_zip IN ('78023', '78056', '78073', '78109', '78112', '78154', '78201', '78202', '78203', '78204', '78205', '78207', '78208', '78209', '78210', '78211', '78212', '78213', '78214', '78215', '78216', '78217', '78218', '78219', '78220', '78221', '78222', '78223', '78224', '78225', '78226', '78227', '78228', '78229', '78230', '78231', '78232', '78233', '78234', '78235', '78236', '78237', '78238', '78239', '78240', '78242', '78243', '78244', '78245', '78247', '78248', '78249', '78250', '78251', '78252', '78253', '78254', '78255', '78256', '78257', '78258', '78259', '78260', '78263', '78264', '78266')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment