使用SQL检查房间的可用性 [英] check availability of a room with SQL

问题描述

我想检查在开始日期和结束日期之间是否有可用的房间.我正在使用Web服务功能来执行此操作.此功能返回给定房间的所有预订的清单.如果此列表为空，则房间可用，否则为空.知道我有这个查询.但这总是回馈我所有的保留.

I want to check if a certain room is available between a start and end date. I am doing this with a webservice function. This function gives back a list with all the reservations of a given room. If this list is empty, the room is available, else it's not. For know I have this query. But it always gives back all my reservations.

SELECT * FROM ARTICLES_RESERVERING res
INNER JOIN ARTICLES_ZAAL roo ON res.ZAALID = roo.ID 
WHERE roo.ID = @ZAALID
AND res.DATUM_BEGIN >= @DATUM_EINDE OR res.DATUM_EINDE <= @DATUM_BEGIN

有人可以帮忙吗?

推荐答案

AND的优先级高于OR.

将最后一行更改为:

AND (res.DATUM_BEGIN >= @DATUM_EINDE OR res.DATUM_EINDE <= @DATUM_BEGIN)

这篇关于使用SQL检查房间的可用性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！