select distinct jz,lb from bsperson where not EXISTS
(select chuqin.jz,chuqin.lb [color=#FF0000]from chuqin,bsperson where chuqin.jz=bsperson.jz and chuqin.lb=bsperson.lb[/color])
SQL code
select distinct jz,lb from bsperson where not exists
(select jz,lb [color=#FF0000]from chuqin where chuqin.jz=bsperson.jz and chuqin.lb=bsperson.lb[/color])
------解决方案-------------------- 第1个里面有两个 相同的表 bsperson ,都没有指定别名,所以无法确定 bsperson.js 是哪个表的
------解决方案-------------------- select distinct jz,lb from bsperson where not EXISTS (select chuqin.jz,chuqin.lb from chuqin,bsperson where chuqin.jz=bsperson.jz and chuqin.lb=bsperson.lb)