--使用 EXISTS 替代 IN 子查询

SELECT DISTINCT sva.*,
uma.sfid AS unified_account_ac_id,
uma."name" AS unified_account_name,
uma.accloud__entity_name__c AS unified_account_entity_name,
uma.recordtypeid AS unified_account_record_type_id,
uma.accloud__status__c AS unified_account_status,
uma.accloud__investment_source__c AS unified_account_investment_source
FROM v_share_visible_account_new sva
INNER JOIN accloud__fta_financial_account_uma__c uma
ON sva.contact_ac_id = uma.accloud__record_owner__c
WHERE EXISTS (
SELECT 1
FROM accloud__fta_financial_account_uma__c
WHERE accloud__primary_owner__c = sva.account_ac_id
AND accloud__record_owner__c = uma.accloud__record_owner__c
);

sql
SELECT DISTINCT sva.*,
uma.sfid AS unified_account_ac_id,
uma."name" AS unified_account_name,
uma.accloud__entity_name__c AS unified_account_entity_name,
uma.recordtypeid AS unified_account_record_type_id,
uma.accloud__status__c AS unified_account_status ,
uma.accloud__investment_source__c AS unified_account_investment_source
FROM v_share_visible_account_new sva
INNER JOIN accloud__fta_financial_account_uma__c uma
ON sva.contact_ac_id=uma.accloud__record_owner__c
AND sva.account_ac_id=uma.accloud__primary_owner__c

SELECT sva.*
FROM accloud__fta_financial_account_uma__c sva
WHERE EXISTS (
SELECT 1
FROM ac_cloud_team_shared_record_relation tsrr
INNER JOIN ac_cloud_team_user_relation tur ON tsrr.team_id = tur.team_id
INNER JOIN ac_cloud_team t ON t.ac_id = tur.team_id AND t.activate = TRUE
WHERE tur.contact_id = sva.contact_ac_id
AND tsrr.shared_sobjecttype = 'accloud__fta_financial_account_uma__c'
AND sva.sfid = tsrr.shared_record_id
)