For Postgres & MS SQL

SELECT ad.ORG_NAME AS "账户", ad.ORG_NAME AS "账户", cisite.NAME AS "地点" FROM AccountCI account LEFT JOIN BaseElement baseci ON account.CIID=baseci.CIID LEFT JOIN CI ci ON baseci.CIID=ci.CIID LEFT JOIN SDOrganization cisite ON ci.SITEID=cisite.ORG_ID LEFT JOIN AccountSiteMapping asm ON ci.SITEID=asm.SITEID LEFT JOIN AccountDefinition ad ON asm.ACCOUNTID=ad.ORG_ID ORDER BY 1