mysql - 一直提示错误105

Question

我正在尝试为数据库的 SQL 服务器编写 q 查询，在该数据库中检索墨尔本所有拥有特大号床的酒店的 HotelID 和名称，但字段列表中的 HotelID 不明确，我不知道如何解决这个问题？这是我的查询

SELECT      City, BedTypeDesc, HotelName, HotelID 
FROM     BedTypes,     Hotels,     Cities,     Rooms 
WHERE     Hotels.CityID = Cities.CityID         AND Hotels.HotelID = Rooms.HotelID          AND Rooms.BedTypeID = BedTypes.BedTypeID         AND BedTypeDesc = 'King Size'         AND City = 'Melbourne' 

Answer 1

您应该使用表别名和正确的 join 语法:

SELECT c.City, bt.BedTypeDesc, h.HotelName, h.HotelID 
FROM Hotels h JOIN
     Cities c
     ON h.CityID = c.CityID JOIN
     Rooms r
     ON h.HotelID = r.HotelID JOIN
     BedTypes bt
     ON r.BedTypeID = bt.BedTypeID         
WHERE bt.TypeDesc = 'King Size' AND c.City = 'Melbourne' ;