你试试 select distinct t.ta_system_code,
t.ta_account_no,
t.cust_name,
t.ta_cfm_serial_no,
t.transaction_cfm_date,
t.product_code,
t.transaction_type
from cr_transaction t
left join cr_cust_calc_load_balance c on t.ta_account_no = c.ta_account_no
left join cr_transaction t2 on t.ta_cfm_serial_no = t2.ta_cfm_serial_no
left join cr_customer_account m on t.ta_account_no = m.ta_account_no
where t.ta_return_code = ‘0000’
and c.ta_account_no is null
and t2.ta_cfm_serial_no is null
and t.ta_system_code = ‘ETFTA’
and m.ta_account_no is not null;