与外部联接相关时，如何从表中选择列的子集？
|
select a.cust_xref_id, a.est_hour, a.phone_nbr as number, a.credit_calls, a.credit_rpcs, b.sdp_calls
from #temp0 a
full outer join #temp2 b
on a.cust_xref_id = b.sdp_cust_xref_id
and a.est_hour = b.sdp_hour
and a.phone_nbr = b.sdp_phone
sdp_cust_xref_id
sdp_hour
sdp_phone
没有找到相关结果
已邀请:
1 个回复
届甸衬丝蚕
，它将为您提供表b中的值：select COALESCE(a.cust_xref_id, b.sdp_cust_xref_id) as cust_xref_id, COALESCE(a.est_hour, b.spd_hour) as est_hour, COALESCE(a.phone_nbr, b.spd_phone) as number, a.credit_calls, a.credit_rpcs, b.sdp_calls from #temp0 a full outer join #temp2 b on a.cust_xref_id = b.sdp_cust_xref_id and a.est_hour = b.sdp_hour and a.phone_nbr = b.sdp_phone