Skip to content

Instantly share code, notes, and snippets.

@saulhappy

saulhappy/current_san_antonio_cust.sql

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.
Download ZIP
current san antonio customers
Raw
current_san_antonio_cust.sql
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