MS-SQL

select cab.name as "CAB Name", usr.first_name "CAB Member",AaaContactInfo.EMAILID AS'Email' from cabdefinition cab left join cabmembers members on cab.cabid = members.cabid left join aaauser usr on members.userid = usr.user_id LEFT JOIN AaaUserContactInfo ON usr.USER_ID=AaaUserContactInfo.USER_ID

LEFT JOIN AaaContactInfo ON AaaUserContactInfo.CONTACTINFO_ID=AaaContactInfo.CONTACTINFO_ID order by 1;