Posted on 2003-11-28
I have three table
I want to find the sname of suppliers who supply EVERY RED part
My query is as the follow :it doesnt return any row for me.What is wrong???
SELECT s.sname, p.pid
FROM supplier AS s, part AS p, catalogue AS c
WHERE (((p.pid)=c.pid) And ((s.sid)=c.sid))
PID IN (SELECT PID FROM PARTS WHERE COLOR=""RED")
I think this only returns suppliers naem who supply any red parts.