Version : 11027

DB : PGSQL / MSSQL

OUTPUT :

SELECT aaauser.FIRST_NAME AS "First Name",
AaaContactInfo.EMAILID AS "Email",
hd.displayname FROM PortalUsers ptu
LEFT JOIN SDUser sduser ON ptu.USERID=sduser.USERID
LEFT JOIN AaaUser aaauser ON sduser.USERID=aaauser.USER_ID
LEFT JOIN helpdeskdetails hd on ptu.helpdeskid = hd.id
LEFT JOIN AaaUserContactInfo ON aaauser.USER_ID=AaaUserContactInfo.USER_ID
LEFT JOIN AaaContactInfo ON  AaaUserContactInfo.CONTACTINFO_ID=AaaContactInfo.CONTACTINFO_ID