就是我只想得到
ZBXH BHFL DWDM DWMC YGCL SGDWDM YEAR_M
---------------- ---------- ------ ---------------- ---------- ------ ------
20030630B 109776 000001 信息部 50000 000001 200306
20030630C 109776 000002 合同部 20000 000002 200306
ZBXH BHFL DWDM DWMC YGCL SGDWDM YEAR_M
---------------- ---------- ------ ---------------- ---------- ------ ------
20030630B 109776 000001 信息部 50000 000001 200306
20030630C 109776 000002 合同部 20000 000002 200306
select zbxh,bhfl,dwdm,dwmc,ygcl,sgdwdm,year_m form JZXX where cast(dwdm as varchar(10))+cast(year_m as varchar(10)) not in (select cast(dwdm as varchar(10))+cast(year_m as varchar(10)) from JZXX )
select zbxh,bhfl,dwdm,dwmc,ygcl,sgdwdm,year_m form CM_V_JZXX_ALL where cast(dwdm as varchar(10))+cast(year_m as varchar(10)) not in (select cast(dwdm as varchar(10))+cast(year_m as varchar(10)) from CM_V_JZXX_ALL)