select * from table ak where v_dwdm||v_ny||v_machineid not in (select dwdm||ny||machineid from bk )
有缺陷,如ak.dwdm=105 bk.dwdm=10 ak.ny=082,bk.ny=5082 且machineid相同,如果字段内容的length确定就没问题了
select * from table ak where v_dwdm||v_ny||v_machineid not in (select dwdm||ny||machineid from bk )
有缺陷,如ak.dwdm=105 bk.dwdm=10 ak.ny=082,bk.ny=5082 且machineid相同,如果字段内容的length确定就没问题了