SELECT DISTINCT reservation.day
FROM reservation
WHERE NOT EXISTS
(SELECT * FROM boat, reservation r1
WHERE boat.color = 'red' AND r1.bname = boat.bname AND NOT EXISTS
(SELECT * FROM reservation r
WHERE reservation.day = r.day AND r.bname = boat.bname ))
anyone could help convert this query using create view??
thanks?
How 'bout a quick explanation of what you want this query to do?
No comments:
Post a Comment