First page Back Continue Last page Overview Graphics
Küme işlemleri (devam)
Hem kırmızı hem de yeşil bot rezerve etmiş yatçılar
SELECT S.sname
FROM Sailors S, Reserves R1, Boats B1, Reserves R2, Boats B2
WHERE S.sid = R1.sid AND R1.bid = B1.bid
AND S.sid = R2.sid AND R2.bid = B2.bid
AND B1.color=`red' AND B2.color = `green'