good day experts!! i would like to ask why do i get this error?
[FONT=Times New Roman][SIZE=3]SELECT tbl_rooms.,tbl_cottage_number.,tbl_cottage_type.,tbl_room_number. FROM tbl_rooms,tbl_cottage_number,tbl_cottage_type,tbl_room_number WHERE tbl_rooms.FK_cottage_type=tbl_cottage_type.PK_cottage_type_id AND tbl_rooms.FK_cottage_number=tbl_cottage_number.PK_cottage_number_id AND tbl_rooms.FK_room_number=tbl_room_number.PK_room_number_id AND tbl_cottage_type.PK_cottage_type_id = 1 AND tbl_rooms.PK_room_id NOT IN (SELECT tbl_booking.FK_rooms FROM tbl_booking WHERE (tbl_booking.check_in_date <= ‘2008-01-07 08:00:00’ AND tbl_booking.check_out_date BETWEEN ‘2008-01-07 08:00:00’ AND ‘2008-01-08 07:50:00’) OR (tbl_booking.check_in_date BETWEEN ‘2008-01-07 08:00:00’ AND ‘2008-01-08 07:50:00’ AND tbl_booking.check_out_date <= 2008-01-08 07:50:00))[/SIZE][/FONT]
in mysql query browser it says:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘07:50:00))’ at line 1
please help me correct my syntax… thanks!!