Version : 13002

DB : MSSQL / PGSQL

OUTPUT :

select ad.org_name "Account Associated",
anno.TITLE "Announcement Title",
LONGTODATE(anno.CREATEDDATE) "Created time",
LONGTODATE(anno.DATE_TO) "End time" from announcement anno
Left JOIN announcementaccountmapping annaccmap on anno.announceid = annaccmap.announceid
Left JOIN accountdefinition ad on annaccmap.accountid = ad.org_id