我想得到sz010in表中 SZ010INFPC=SZ070PDFPC and SZ010INGOODSCODE=SZ070PDGOODSCODE的但
sz010incode<>szo70pdcode不等的纪录怎么写啊?下面我写的不对啊,因为sz010in 中存在下面的纪录sz010incode SZ010INGOODSCODE SZ010INFPC
16840797210 NN423326 NN423326
16840797220 NN423326 NN423326
16840797240 NN423326 NN423326
16840797270 NN423326 NN423326select sz010in.* from sz010in ,(select szo70pdcode,sz070pdfpc,sz070pdgoodscode from sz070pd where sz070pdstate=0)a
where sz010incode<>szo70pdcode and SZ010INFPC=SZ070PDFPC and SZ010INGOODSCODE=SZ070PDGOODSCODE
sz010incode<>szo70pdcode不等的纪录怎么写啊?下面我写的不对啊,因为sz010in 中存在下面的纪录sz010incode SZ010INGOODSCODE SZ010INFPC
16840797210 NN423326 NN423326
16840797220 NN423326 NN423326
16840797240 NN423326 NN423326
16840797270 NN423326 NN423326select sz010in.* from sz010in ,(select szo70pdcode,sz070pdfpc,sz070pdgoodscode from sz070pd where sz070pdstate=0)a
where sz010incode<>szo70pdcode and SZ010INFPC=SZ070PDFPC and SZ010INGOODSCODE=SZ070PDGOODSCODE
where sz010incode<>a.szo70pdcode and SZ010INFPC=a.SZ070PDFPC and SZ010INGOODSCODE=a.SZ070PDGOODSCODE
如:sz010in表中有
16840797210 NN423326 NN423326
16840797220 NN423326 NN423326
16840797240 NN423326 NN423326
16840797270 NN423326 NN423326
而sz070pd中有
16840797240 NN423326 NN423326
16840797270 NN423326 NN423326
则结果为
16840797210 NN423326 NN423326
16840797220 NN423326 NN423326
16840797210 NN423326 NN423326
16840797220 NN423326 NN423326
left join (select szo70pdcode,sz070pdfpc,sz070pdgoodscode from sz070pd where sz070pdstate=0) b
where a.sz010incode<>b.szo70pdcode and a.SZ010INFPC=b.SZ070PDFPC and a.SZ010INGOODSCODE=b.SZ070PDGOODSCODE
left join (select szo70pdcode,sz070pdfpc,sz070pdgoodscode from sz070pd where sz070pdstate=0) b
where a.sz010incode<>b.szo70pdcode and a.SZ010INFPC=b.SZ070PDFPC and a.SZ010INGOODSCODE=b.SZ070PDGOODSCODE
on sz010incode<>szo70pdcode and SZ010INFPC=SZ070PDFPC and SZ010INGOODSCODE=SZ070PDGOODSCODE
select b.* from sz010in b left join (select szo70pdcode,sz070pdfpc,sz070pdgoodscode from sz070pd where sz070pdstate=0)a
on (a.sz010incode<>b.szo70pdcode and a.SZ010INFPC=b.SZ070PDFPC and a.SZ010INGOODSCODE=b.SZ070PDGOODSCODE)
如:sz010in表中有
16840797210 NN423326 NN423326
16840797220 NN423326 NN423326
16840797240 NN423326 NN423326
16840797270 NN423326 NN423326
而sz070pd中有
16840797240 NN423326 NN423326
16840797270 NN423326 NN423326
结果因该为
16840797240 NN423326 NN423326
16840797270 NN423326 NN423326
请问各位语句要怎么写啊?