Change an msaccess query to mysql!

the query in access is

SELECT DISTINCT ROOMS.*
FROM ROOMS INNER JOIN bookings ON ROOMS.id = bookings.rid
WHERE ((([start])<[bookings].[date_in]) AND (([end])<[bookings].[date_in])) OR ((([start])>[bookings].[date_out]) AND (([end])>[bookings].[date_out]));



i need the mysql query thatis similar to it any help?

 

Try this:

SELECT DISTINCT ROOMS.*
FROM ROOMS INNER JOIN bookings ON ROOMS.id = bookings.rid
WHERE (start<bookings.date_in AND end<bookings.date_in)
OR (start>bookings.date_out AND end>bookings.date_out);

Code (markup):

Brew

 

well the first part is like this

select rooms.* from rooms,bookings
where.........


here is the problem !