Skip to content

Instantly share code, notes, and snippets.

@nakamura-to

nakamura-to/union.sql

Created November 10, 2014 05:55
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 nakamura-to/4c8f94d82216bb401f1d to your computer and use it in GitHub Desktop.
Save nakamura-to/4c8f94d82216bb401f1d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
union.sql
select email from table_a
where
primaryDomain = /*domain*/'hoge.com'
union
select email from table_b
where
/*%if userIds.size() > 0 */
member_id in /*userIds*/('aaa', 'bbb')
/*%else */
and
1 <> 1
/*%end */
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment