select t.*,c.cityname,c1.cityname from Ticket t join CityInfo c on t.FromCityId = c.cityid join CityInfo c on t.ToCityId = c2.ToCityId??
select t.*,c.cityname,c1.cityname from Ticket t join CityInfo c on t.FromCityId = c.cityid join CityInfo c1 on t.ToCityId = c1.cityid
select TicketId,FlightOrder,price,leaveDate,roomType,case FromCity when FromCity then --使用case函数进行匹配 (select cityName from CityInfo where CityId in (select fromCity from TicketInfo )) --子查询根据Id查出名字 end as FromCity, case ToCity when ToCity then --使用case函数进行匹配 (select cityName from CityInfo where CityId in (select ToCity from TicketInfo )) --子查询根据Id查出名字 end as ToCity from TicketInfo除了这个方法还有什么方法没??1 ft3001 1 5 100.00 2010-01-20 00:00:00.000 1 --行11 ft3001 长春 哈尔滨 100.00 2010-01-20 00:00:00.000 1 --行2 由行1 变成行21和5是外键,表中的字段是Id,显示时为cityName就是这个意思
join CityInfo c on t.ToCityId = c2.ToCityId??
join CityInfo c1 on t.ToCityId = c1.cityid
(select cityName from CityInfo
where CityId in (select fromCity from TicketInfo )) --子查询根据Id查出名字
end as FromCity,
case ToCity when ToCity then --使用case函数进行匹配
(select cityName from CityInfo
where CityId in (select ToCity from TicketInfo )) --子查询根据Id查出名字
end as ToCity from TicketInfo除了这个方法还有什么方法没??1 ft3001 1 5 100.00 2010-01-20 00:00:00.000 1 --行11 ft3001 长春 哈尔滨 100.00 2010-01-20 00:00:00.000 1 --行2
由行1 变成行21和5是外键,表中的字段是Id,显示时为cityName就是这个意思