这个合并查询要怎么写？

[steven7677]

userID exYear
1 2007
2 2007
1 2008

现在想查询2007~2009年的情况，形成下表
userID exYear
1 2009
1 2008
1 2007
2 2009
2 2008
2 2007

[闽之东]

select UserID from 表名 where exYear in (2007,2008,2009) order by UserID

[dawugui]

select m.userid , n.exyear from
(select distinct userID from tb) m,
(select 2009 as exYear union all select 2008 union all 2007) n

[htl258_Tony]

select a.userid,b.exyear
from (select distinct userid from tb) a,
 (select exyear=2007 union select 2008 union select 2009) b

[快乐_石头]

ORDER BY userID, exYear  DESC

[dawugui]

create table tb(userID int,exYear int)
insert into tb values(1 ,     2007 )
insert into tb values(2 ,     2007 )
insert into tb values(1 ,     2008 )
go

select m.userid , n.exyear from
(select distinct userID from tb) m,
(select 2009 as exYear union all select 2008 union all select 2007) n

drop table tb

/*
userid      exyear      
----------- ----------- 
1           2009
1           2008
1           2007
2           2009
2           2008
2           2007

（所影响的行数为 6 行）
*/

[htl258_Tony]

慢老大一点

[claro]

帮顶
已有贴回复类似问题。

[claro]

select * from (select 1 userid union all select 2) b ,
(select 2009 as exYear union all select 2008 union all select 2007) bb
userid	exYear
1	2009
1	2008
1	2007
2	2009
2	2008
2	2007
(6 行受影响)

数据好弄，需求应该不是这样。

[rucypli]

select userid,exYear
from tb
group by userid,exYear
order by userid,exYear

[ACMAIN_CHM]

select distinct userID,b.xy as exYear
from userID,(select 2007 as xy union all select 2008 as xy union all select 2009 as xy) b

[syw_java]

怎么像是拼出来的