SELECT dh,sl,yqsdrq,L,W,M2 FROM xsddmx
WHERE dh in(select dh from xsdd where zt = 1 )
AND not exists(select 1 from zscjh WHERE zscjh.cpbh=xsddmx.cpbh and zscjh.dh=xsddmx.dh and zscjh.L=xsddmx.L and zscjh.W=xsddmx.W )
and cpbh='00005'
WHERE dh in(select dh from xsdd where zt = 1 )
AND not exists(select 1 from zscjh WHERE zscjh.cpbh=xsddmx.cpbh and zscjh.dh=xsddmx.dh and zscjh.L=xsddmx.L and zscjh.W=xsddmx.W )
and cpbh='00005'