Guest User

Untitled

a guest
Mar 20th, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. SELECT DB1.20180320.email
  2. FROM DB1.20180320
  3. left join DB2.20180319 on DB1.20180320.email = DB2.20180319.email
  4. AND DB2.20180319.Status = 'active'
  5. WHERE DB2.20180319.email IS null;
  6.  
  7. (SELECT DB2.20180319.email
  8. FROM DB2.20180319
  9. WHERE Status = 'active'
  10. AND DB2.20180319.email IS NOT NULL)
Add Comment
Please, Sign In to add comment