本来是两条sql语句
--预订间夜top 10
SELECT hotel_name, SUM (rooms)
AS 预订间夜
FROM tbooked_info1
GROUP BY hotel_name
ORDER BY 预订间夜 DESC--实际入住top 10
SELECT hotel_name, SUM(rooms)
AS 入住间夜
FROM tBookedinfo0
WHEREGROUP BY hotel_name
ORDER BY 入住间夜 DESC现在要求结果为: 酒店名 预订间夜 入住间夜 这样的结果,按照预订间夜排序,怎么写sql?
--预订间夜top 10
SELECT hotel_name, SUM (rooms)
AS 预订间夜
FROM tbooked_info1
GROUP BY hotel_name
ORDER BY 预订间夜 DESC--实际入住top 10
SELECT hotel_name, SUM(rooms)
AS 入住间夜
FROM tBookedinfo0
WHEREGROUP BY hotel_name
ORDER BY 入住间夜 DESC现在要求结果为: 酒店名 预订间夜 入住间夜 这样的结果,按照预订间夜排序,怎么写sql?
FROM tbooked_info1 t1 inner join tBookedinfo0 t2 on t1.hotel_name=t2.hotel_nameORDER BY 预订间夜 DESC
from
(
SELECT hotel_name, SUM (rooms) AS 预订间夜
FROM tbooked_info1
GROUP BY hotel_name
ORDER BY 预订间夜 DESC
)as a inner join
(
SELECT hotel_name, SUM(rooms)
AS 入住间夜
FROM tBookedinfo0
GROUP BY hotel_name
ORDER BY 入住间夜 DESC
) as b
on a.hotel_name=b.hotel_name
lz 也是搞酒店预订web开发的么?
同行哈 ^_^