SELECT * FROM EVENT_DBA.ANNOUNCEMENT, MED_CORE.MED, MED_CORE.EMAIL, MED_CORE.PHONE_NBR WHERE ANNOUNCEMENT.DEPT_ID_SEQ IN (143,145) AND MED.MED_ID_SEQ = ANNOUNCEMENT.MEDIA_CONTACT_MED_ID_SEQ AND EMAIL.MED_ID_SEQ = ANNOUNCEMENT.MEDIA_CONTACT_MED_ID_SEQ AND PHONE_NBR.MED_ID_SEQ = ANNOUNCEMENT.MEDIA_CONTACT_MED_ID_SEQ AND ANNOUNCEMENT_ID_SEQ =

To:* (separate multiple recipients with a comma) Your Name:* Your Email:* (a courtesy copy of this email will be sent to you also) Subject: #dateFormat(ParseDateTime(ANNOUNCEMENT_START_DT), "dd mmmm yyyy")# - #ANNOUNCEMENT_SHORT_DESC# Message: (please add your comments to the email) #ParagraphFormat(ANNOUNCEMENT_LONG_DESC&ANNOUNCEMENT_LONG_DESC_2)#

<<::Back to Press Releases