saranraj subramaniam
December 29, 2011
regarding minus query
wat's the another way of writing the query for the following query,
select sid from sailor where sid in (select r.sid from reserv r, boats b where color like 'red' and b.bid = r.bid )minus
select sid from sailor where sid in (select r.sid from reserv r, boats b where color like 'green' and b.bid = r.bid )