我在SQL Server中有两个表
City_Master(
ID bigint,
Name nvarchar(50)
)
Tour_Details(
ID bigint,
From_City bigint,
To_City bigint,
Details nvarchar(max),
Cost nvarchar(100),
Tour_Name nvarchar(100),
Duration nvarchar(max))
Tour_Details表From_City和To_City中的列来自City_Master表。我想选择ID为城市的名称,该城市位于Tour_Details表的From_City和To_City列中。
我已经为此使用了以下sql查询
SELECT Tour_Details.ID, Tour_Details.Tour_Name, Tour_Details.From_City, Tour_Details.To_City, Tour_Details.Cost,
Tour_Details.Details,Tour_Details.Duration, City_Master.Name as City FROM Tour_Details INNER JOIN
City_Master ON Tour_Details.From_City = City_Master.ID ORDER BY Tour_Details.ID DESC
但它仅返回一个城市名称,但tour_Details表列中存在两个城市ID,分别为From_City,To_City。我想要两个城市的名字。任何人都可以帮我
试试这个
SELECT Tour_Details.ID, Tour_Details.Tour_Name, Tour_Details.From_City, Tour_Details.To_City, Tour_Details.Cost,
Tour_Details.Details,Tour_Details.Duration, B.Name as FromCityName, A.Name as ToCityName
FROM Tour_Details
INNER JOIN City_Master B ON B.ID = Tour_Details.From_City
INNER JOIN City_Master A ON A.ID = Tour_Details.To_City
ORDER BY Tour_Details.ID DESC
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句