Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT (E.EMAIL_ADDRESS), DISTINCT (DATE(EM.MESSAGE_DATE))
- FROM (
- SELECT EMAIL
- FROM EMAIL.TO
- UNION ALL
- SELECT EMAIL
- FROM EMAIL.CC
- ) AS A
- INNER JOIN EMAIL.PERSON AS E
- ON A.EMAIL = E.EMAIL_ADDRESS
- INNER JOIN EMAIL.EMAILS AS EM
- ON DATE(EM.MESSAGE_DATE) BETWEEN '2001.09.01' AND '2001.10.31'
- ORDER BY DATE(EM.MESSAGE_DATE) ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement