SELECT t1.TBB,t2.ID FROM (SELECT DISTINCT tb.ID tbb FROM TESTB tb) t1,TESTA t2
WHERE NOT EXISTS(SELECT 1 FROM TESTB tb2 WHERE tb2.ID||tb2.ID1=t1.TBB||t2.ID )
ORDER BY t1.TBB,t2.ID
这样是可以的
SELECT t1.TBB,t2.ID FROM (SELECT DISTINCT tb.ID tbb FROM TESTB tb) t1,TESTA t2
WHERE NOT EXISTS(SELECT 1 FROM TESTB tb2 WHERE tb2.ID=t1.TBB AND tb2.ID1=t2.ID )
ORDER BY t1.TBB,t2.ID
这样就不行
问了很多人一直在说||的事情。。。。