SELECT s1.roomtype, s2.roomno, s1.checkin,s1.checkout
FROM guestrocordtransac s1
JOIN guestrocord s2
ON s1.roomtype = s2.roomtype AND s1.roomno != s2.roomno
WHERE s1.checkin="2015-06-06 00:00:00"
BETWEEN s2.checkin="2015-06-06 00:00:00" AND s2.check0ut="2015-06-13 00:00:00"
SELECT s1.roomtype, s2.roomno, s1.checkin,s1.ch
阅读背景：
我在测试inlocalhost phpmyadmin时无法执行我的mysql查询？
来源：互联网
分享到：
