Advertisement
borsha06

EX-5.2

May 8th, 2021
3,758
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.38 KB | None | 0 0
  1. SELECT (E.EMAIL_ADDRESS), DISTINCT (DATE(EM.MESSAGE_DATE))
  2.  FROM (
  3.      
  4.         SELECT EMAIL
  5.         FROM EMAIL.TO
  6.         UNION ALL
  7.         SELECT EMAIL
  8.         FROM EMAIL.CC
  9.   ) AS A
  10. INNER JOIN EMAIL.PERSON AS E
  11. ON A.EMAIL = E.EMAIL_ADDRESS
  12. INNER JOIN EMAIL.EMAILS AS EM
  13. ON DATE(EM.MESSAGE_DATE) BETWEEN '2001.09.01' AND '2001.10.31'
  14. ORDER BY DATE(EM.MESSAGE_DATE) ASC
  15.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement