SELECT srnkey,srnsrn,srnsku,PKMWNO,PKMLOT FROM SRNOUT LEFT JOIN PKM ON PKMWNO=SRNPLO AND PKMSKU=SRNSKU AND PKMLOT=SRNLOT
WHERE (PKM.PKMWNO = '123456' AND PKMLOT='1234567890')
srnkey ,srnsrn, srnsku, PKMWNO, PKMLOT
14 12345678911234567890 1111 123456 1234567890
15 12345679801234567890 1111 123456 1234567890
16 22345678911234567890 1111 123456 1234567890
11 12345678901234567890 1111 123456 1234567890
12 12345g78901234567890 1111 123456 1234567890
13 15345678901234567890 1111 123456 1234567890
14 12345678911234567890 1111 123456 1234567890
15 12345679801234567890 1111 123456 1234567890
16 22345678911234567890 1111 123456 1234567890
11 12345678901234567890 1111 123456 1234567890
12 12345g78901234567890 1111 123456 1234567890
13 15345678901234567890 1111 123456 1234567890
14 12345678911234567890 1111 123456 1234567890
15 12345679801234567890 1111 123456 1234567890
16 22345678911234567890 1111 123456 1234567890
11 12345678901234567890 1111 123456 1234567890
12 12345g78901234567890 1111 123456 1234567890
13 15345678901234567890 1111 123456 1234567890
14 12345678911234567890 1111 123456 1234567890
15 12345679801234567890 1111 123456 1234567890
16 22345678911234567890 1111 123456 1234567890
11 12345678901234567890 1111 123456 1234567890
12 12345g78901234567890 1111 123456 1234567890
13 15345678901234567890 1111 123456 1234567890怎么消除重复查询
WHERE (PKM.PKMWNO = '123456' AND PKMLOT='1234567890')
1 11 12345678901234567890 1111 123456 1234567890
1 12 12345g78901234567890 1111 123456 1234567890
1 13 15345678901234567890 1111 123456 1234567890
1 14 12345678911234567890 1111 123456 1234567890
1 15 12345679801234567890 1111 123456 1234567890
1 16 22345678911234567890 1111 123456 1234567890
3 11 12345678901234567890 1111 123456 1234567890
3 12 12345g78901234567890 1111 123456 1234567890
3 13 15345678901234567890 1111 123456 1234567890
3 14 12345678911234567890 1111 123456 1234567890
3 15 12345679801234567890 1111 123456 1234567890
3 16 22345678911234567890 1111 123456 1234567890
4 11 12345678901234567890 1111 123456 1234567890
4 12 12345g78901234567890 1111 123456 1234567890
4 13 15345678901234567890 1111 123456 1234567890
4 14 12345678911234567890 1111 123456 1234567890
4 15 12345679801234567890 1111 123456 1234567890
4 16 22345678911234567890 1111 123456 1234567890
5 11 12345678901234567890 1111 123456 1234567890
5 12 12345g78901234567890 1111 123456 1234567890
5 13 15345678901234567890 1111 123456 1234567890
5 14 12345678911234567890 1111 123456 1234567890
5 15 12345679801234567890 1111 123456 1234567890
5 16 22345678911234567890 1111 123456 1234567890
是这个重复的
WHERE ( PKM.PKMWNO = '123456' AND PKMLOT='1234567890')
GROUP BY PKMWNO,PKMLOT,PKMSKU,srnkey123456 1234567890 1111 28 6
NOT EXISTS
子查询应该可以实现