help ...

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?