select A.*,
(select top 1
B.b
from
(
select
'a' as a ,'1' as b
union
select
'b' as a ,'2' as b
union
select
'd' as a ,'3' as b
union
select
'a' as a ,'4' as b
)B where A.a = B.a) as changA
from
(
select
'a' as a ,'1' as b
union
select
'b' as a ,'2' as b
union
select
'c' as a ,'3' as b
)A ;
mssql成功