p.193b
"Find the names of sailors who have reserved boat #103
SELECT S.sname
FROM Sailors S
WHERE EXISTS (SELECT *
FROM Reserves R
WHERE R.bid = 103
AND S.sid = R.sid)
Previous slide
Next slide
Back to first slide
View graphic version