Re: Complex select query

| SELECT r.Room ,
| r.Description
| FROM rooms r ,
| (
| SELECT Room
| COUNT(*) Availability
| FROM bookings
| WHERE Reserved >= ' . $startDate . '
| AND Reserved <= ' . $endDate . '
| GROUP BY Room
| ) b
| WHERE b.Room = r.Room
| AND b.Availability = 0
|

check that! that wouldn't give you what you're expecting...this should:

SELECT Room ,
Description
FROM rooms
WHERE Room NOT IN
(
SELECT Room
FROM bookings
WHERE Reserved >= ' . $startDate . '
AND Reserved <= ' . $endDate . '
)

much better. ;^)


.