Originally Posted by r937
change this --
Code:
  FROM rooms 
LEFT 
  JOIN bookings 
    ON bookings.roomno = rooms.roomno 
   AND bookings.hotel_id = rooms.hotel_id
   AND bookings.status <> 1
 WHERE rooms.hotel_id = 1 and the_date is null or the_date='2013-01-10'
 ORDER 
    BY rooms.roomno
to this --
Code:
  FROM rooms 
LEFT 
  JOIN bookings 
    ON bookings.roomno = rooms.roomno 
   AND bookings.hotel_id = rooms.hotel_id
   AND bookings.status <> 1
   and the_date='2013-01-10'
 WHERE rooms.hotel_id = 1 
 ORDER 
    BY rooms.roomno
Thanks so much Rudy
You are God sent...........It is working the way i want it now.