连接表，但不显示满足where子句的行
连接表，但不显示满足where子句的行
提问于 2012-10-28 05:39:19
我正在连接mysql中的表，但我有一个表，其中包含日期：
table: cutoff
date roomid
---------------------------
2012-11-03 25
2012-11-04 25
2012-11-05 25
2012-11-06 25下面是我的SQL查询：
SELECT t.RoomId, t.USD, t.MXN, i.Image, a.RoomName, a.RoomDesc, cu.date FROM Tarifas AS t
INNER JOIN Images AS i ON i.RoomId = t.RoomId
INNER JOIN Availability AS a ON a.RoomId = t.RoomId
INNER JOIN cutoff AS cu ON cu.roomid = t.RoomId AND cu.date NOT BETWEEN '$from' and '$to'
WHERE t.Start <= '$from' AND t.End >= '$from' ORDER BY USD 我想要获取日期不在截止表中的所有行。但它给了我相反的东西！我不知道该怎么做，在这里提供任何帮助都是非常感谢的！
要添加TARIFA表的EIDT：
table: tarifas
RoomId Start End USD MXN
---------------------------------------------------
25 2012-11-01 2012-11-20 60.00 620.00
26 2012-11-01 2012-11-20 80.00 820.00
27 2012-11-01 2012-11-20 55.00 570.00回答 1
Stack Overflow用户
回答已采纳
发布于 2012-10-28 05:53:24
试试这个(编辑过的)：
SELECT t.RoomId, t.USD, t.MXN, i.Image, a.RoomName, a.RoomDesc
FROM Tarifas AS t
INNER JOIN Images AS i ON i.RoomId = t.RoomId
INNER JOIN Availability AS a ON a.RoomId = t.RoomId
WHERE t.RoomID NOT IN
(SELECT DISTINCT roomid FROM cutoff
WHERE date BETWEEN '$from' AND '$to')
AND t.Start <= '$from' AND t.End >= '$from'
ORDER BY USD 页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/13104425
复制相关文章
相似问题
腾讯云开发者
