Find sailors who’ve reserved at least one boat

• Would adding DISTINCT to this query make a difference?

• What is the effect of replacing S.sid by S.sname in the SELECT clause? Would adding DISTINCT to this variant of the query make a difference?

SELECT S.sid

FROM Sailors S, Reserves R

WHERE S.sid=R.sid

Previous slide

Next slide

Back to first slide

View graphic version