SELECT accountdefinition.org_name,
accountdefinition.support_email,
accountdefinition.sendername,
accountdefinition.login_uri,
aaacontactinfo.emailid,
aaacontactinfo.landline,
aaacontactinfo.mobile,
aaacontactinfo.fax,
aaacontactinfo.web_url,
aaacontactinfo.res_phone,
aaapostaladdress.door_no,
aaapostaladdress.street,
aaapostaladdress.location,
aaapostaladdress.landmark,
aaapostaladdress.city,
aaapostaladdress.postalcode,
aaapostaladdress.state,
aaapostaladdress.country FROM accountdefinition,
sdorgcontactinfo,
aaacontactinfo,
sdorgpostaladdr,
aaapostaladdress WHERE accountdefinition.org_id = sdorgcontactinfo.org_id AND
accountdefinition.org_id = sdorgpostaladdr.org_id AND
sdorgcontactinfo.contactinfo_id = aaacontactinfo.contactinfo_id AND
sdorgpostaladdr.postaladdr_id = aaapostaladdress.postaladdr_id;