# Mysql syntax help

**URL:** <https://forum.kirupa.com/t/mysql-syntax-help/248681>\
**Category:** Uncategorized\
**Created:** [January 10, 2008, 5:32pm UTC](https://forum.kirupa.com/t/mysql-syntax-help/248681 "2008-01-10T17:32:14Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ivlem](https://avatars.discourse-cdn.com/v4/letter/i/a9adbd/32.png) [@ivlem](https://forum.kirupa.com/u/ivlem)\
**Post date:** [January 10, 2008, 5:32pm UTC](https://forum.kirupa.com/t/mysql-syntax-help/248681/1 "2008-01-10T17:32:14Z")

</div>

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!!