SQL语句改写需求：调整FROM从句起始实体为FilteredAccount并重写关联逻辑

补全后的完整SQL语句 #

SELECT 
    pos.bsv_organization,
    CRMAF_org.accountid,
    CRMAF_org.bsv_targetgroupattribute1, 
    pos.bsv_address_multiline, 
    pos.bsv_memberlist_memberlistcode, 
    pos.owneridname, 
    CRMAF_bsv_memberlist.bsv_memberlistcode, 
    pos.bsv_count_german, 
    pos.bsv_count_french,
    pos.bsv_count_italian,
    pos.bsv_count_rr,
    pos.bsv_count_english
FROM FilteredAccount as CRMAF_org
LEFT JOIN Filteredbsv_memberrelation as pos ON pos.bsv_organization = CRMAF_org.accountid
LEFT JOIN Filteredbsv_memberlist as CRMAF_bsv_memberlist ON CRMAF_bsv_memberlist.bsv_memberlistid = pos.bsv_memberlist

关联逻辑说明 #

• 第一重关联：将主表FilteredAccount（别名CRMAF_org）和会员关系表Filteredbsv_memberrelation（别名pos）通过账户ID与组织ID字段关联
• 第二重关联：将会员关系表和会员列表表Filteredbsv_memberlist（别名CRMAF_bsv_memberlist）通过会员列表ID字段关联，和原查询的关联逻辑完全对齐，不会改变原有查询的匹配结果

内容的提问来源于stack exchange，提问作者Paul Richardson