select DWname,title from Drawing whereDWname='张三' and title not in (select title from Archive) group by DWname,titleselect a.DWname,a.title from Drawing a,Archive b where a.titleb.titleand a.DWname='张三'最后一种比前一种和楼上那种效率要高一点,不过这几种结果都是对的...
select distinct * from Drawing where not exists ( select * from Archive where Drawing.title=Archive.title ) and DWname = '张三' 我 试过来 ,输出的结果就是你要的 结果有什么不懂的地方就Q我我们一起讨论一下 ,呵呵 ...