EX-5.2-new

SELECT DISTINCT(EM.ID), E.EMAIL_ADDRESS, EM.MESSAGE_DATE, EM.MESSAGE_SUBJECT, EM.MESSAGE_BODY,EM.MESSAGE_FROM
 FROM (
        SELECT EMAIL
        FROM EMAIL.TO AS TO
        WHERE TO.EMAIL = 'larry.may@enron.com'
        UNION ALL
        SELECT EMAIL
        FROM EMAIL.CC AS CC
        WHERE CC.EMAIL = 'larry.may@enron.com'
  ) 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'
WHERE E.FIRSTNAME = 'Larry' AND E.LASTNAME = 'May'
ORDER BY EM.MESSAGE_DATE, EM.ID ASC