检查两个日期不在两个其他日期+MYSQl之间 - Check two date was not between two another date + MYSQl

Check two date was not between two another date + MYSQl

我正在查询酒店预订和预订系统，但在选择两个日期之间未预订的房间时遇到问题。我的查询与此类似，但它不起作用，查询返回注意到，但实际上我有3个房间，房间类型为1。Sql小提琴：http://sqlfiddle.com/#！2/b97419

SELECT tbl_room.room_no, tbl_room.type_id, tbl_Reservation.room_id
FROM tbl_room
LEFT JOIN tbl_Reservation ON tbl_room.id = tbl_Reservation.room_id
WHERE (
(
tbl_Reservation.checkin_data < '" . $checkin . "'
AND tbl_Reservation.checkout_data < '" . $checkin . "'
)
OR (
tbl_Reservation.checkin_data > '" . $checkout . "'
AND tbl_Reservation.checkout_data > '" . $checkout . "'
)
)
AND tbl_room.type_id =1

谢谢你的帮助，也很抱歉我英语不好。

试试这样的

SELECT 
    tbl_room.room_no, 
    tbl_room.type_id, 
    tbl_room.id,
    tr.id as reserv_status
FROM tbl_room
 LEFT JOIN tbl_Reservation tr ON tbl_room.id = tr.room_id AND 
           (
             (tr.checkin_data <= "'$checkin'" AND tr.checkout_data >= "'$checkin'")
             OR
             (tr.checkin_data <= "'$checkout'" AND tr.checkout_data >= "'$checkout'")
           )
 WHERE 
 tbl_room.type_id =1  AND tr.id IS NULL