select a.*
from cc_clrkdmx a left join cc_rkckmx
on a.zanshoudanbh = b.zanshoudanbh
and a.jiaojiedanbh = b.jiaojiedanbh
and a.rukudanbh = b.rukudanbh
where b.rukudanbh is null
from cc_clrkdmx a left join cc_rkckmx
on a.zanshoudanbh = b.zanshoudanbh
and a.jiaojiedanbh = b.jiaojiedanbh
and a.rukudanbh = b.rukudanbh
where b.rukudanbh is null
from cc_clrkdmx a left join cc_rkckmx b
on a.zanshoudanbh = b.zanshoudanbh
and a.jiaojiedanbh = b.jiaojiedanbh
and a.rukudanbh = b.rukudanbh
where b.rukudanbh is null
from cc_clrkdmx a left join cc_rkckmx b
on a.zanshoudanbh = b.zanshoudanbh
and a.jiaojiedanbh = b.jiaojiedanbh
and a.rukudanbh = b.rukudanbh
and ...
where b.zanshoudanbh is null--只要列出一个字段为null 就可以了
select a.*
from cc_clrkdmx a full join cc_rkckmx b
on a.zanshoudanbh = b.zanshoudanbh
and a.jiaojiedanbh = b.jiaojiedanbh
and a.rukudanbh = b.rukudanbh
and ...
where b.zanshoudanbh is null or a.zanshoudanbh is null