Mssql问题(请高手帮忙)

来源：百度知道 编辑：UC知道 时间：2024/09/23 04:06:21
我用的是mssql 想显示出内容
=============================================
DayNo("第一天,第二天....")[指天数],
City("北京,广州.....")[指城市]
No(1,2,3,4,5,6,7,8.....)[指不重复的序号],
ConfirmType1[就只有1,2 两个1表示出发城市,2表示到达城市]
=============================================
原Table1名称ItemSchedule[里面内容有(No,DayNo,SCityCode,ECityCode,
Name ,ConfirmType1,ConfirmType2)]
原Table2名称City[CityCode,Name]
=================================================
select distinct a.DayNo,a.CityCode from
(
select e.No as No,DayNo,SCityCode,f.Name as City,e.ConfirmType1
from
(ItemSchedule as e join City as f on e.SCityCode = f.CityCode ) join City as g on e.ECityCode = g.CityCode
where OrderCode = 'RJ2008-06-2301 ' And ItemNo = 1
Union all
select e.No as No,DayNo,ECityCode ,g.Name as EndCity,ConfirmType2
from
(ItemSchedule as e join City as f on e.SCityCode = f.CityCode ) join City as g on e.ECityCode = g.CityCode

select distinct a.DayNo,a.CityCode from
(
select e.No as No,DayNo,SCityCode,f.Name as City,e.ConfirmType1
from
(ItemSchedule as e inner join City as f on e.SCityCode = f.CityCode ) inner join City as g on e.ECityCode = g.CityCode
where OrderCode = 'RJ2008-06-2301 ' And ItemNo = 1
Union all
select e.No as No,DayNo,ECityCode ,g.Name as EndCity,ConfirmType2
from
(ItemSchedule as e inner join City as f on e.SCityCode = f.CityCode ) inner join City as g on e.ECityCode = g.CityCode
where OrderCode = 'RJ2008-06-2301 ' And ItemNo = 1 Order by DayNo,No,e.ConfirmType1) a
这样试试