SELECT splname FROM qspl
WHERE splno NOT IN
(SELECT splno FROM qdel
WHERE itemname = 'Compass'
OR itemname = 'Geopositioning System');
Select splname
From qdel a,qspl b
Where a.splno=b.splno
And (a.itemname != ('Compass') or a.itemname != ('Geopositioning System'))
这是ERD图
图片说明