使用子查询这些查询合并为 1
it1352
帮助1人
问题说明
Select * from HotelPerson
Where RoomID IN (select ID from HotelRoom Where BookingID = 36 )
Select * from HotelCancelationPolicy
Where RoomID IN (select ID from HotelRoom Where BookingID = 36 )
如何将这两个查询合并为 1 个查询?
How can I merge these both queries into 1 query ?
正确答案
#1
这会将两个表中的所有列都显示在一个表中.
This will give you all the columns from both tables in one table.
SELECT *
FROM HotelPerson A, HotelCancelationPolicy B
WHERE A.RoomID = B.RoomID
AND A.RoomID IN (SELECT ID FROM HotelRoom WHERE BookingID = 36)
这篇好文章是转载于：学新通技术网
