select A.name, B.name, C.name from [user] left join base as A on [user].id1=A.id left join base as B on [user].id2=B.id left join base as C on [user].id3=C.id
create table base(id int, name varchar(10)) insert base select 1, 'a' union all select 2, 'b' union all select 3, 'c'create table [user](id1 int, id2 int, id3 int) insert [user] select 1, 2, 3select id1=A.name, id2=B.name, id3=C.name from [user] left join base as A on [user].id1=A.id left join base as B on [user].id2=B.id left join base as C on [user].id3=C.id--result id1 id2 id3 ---------- ---------- ---------- a b c(1 row(s) affected)
left join base as A on [user].id1=A.id
left join base as B on [user].id2=B.id
left join base as C on [user].id3=C.id
insert base select 1, 'a'
union all select 2, 'b'
union all select 3, 'c'create table [user](id1 int, id2 int, id3 int)
insert [user] select 1, 2, 3select
id1=A.name,
id2=B.name,
id3=C.name
from [user]
left join base as A on [user].id1=A.id
left join base as B on [user].id2=B.id
left join base as C on [user].id3=C.id--result
id1 id2 id3
---------- ---------- ----------
a b c(1 row(s) affected)