Skip to content

Instantly share code, notes, and snippets.

@ejhayes

ejhayes/union.sql

Created August 13, 2010 18:27
Show Gist options
  • Save ejhayes/523314 to your computer and use it in GitHub Desktop.
Save ejhayes/523314 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
union.sql
select AR_ID from SPECUSE.ARS_APPLICATION_REV_SITES ARS where SITE_CODE in (14022)
union
select AR_ID from SPECUSE.ARP_APPLICATION_REV_PESTS ARP where P_CODE in (549)
union
select AR_ID from SPECUSE.ARC_APPLICATION_REV_COUNTIES where C_CODE in (34)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment