select a.id,
ScanName = (select name from b where id = a.scan) ,
TestName = (select name from b where id = a.Test) ,
TrainName = (select name from b where id = a.Train)
from a
ScanName = (select name from b where id = a.scan) ,
TestName = (select name from b where id = a.Test) ,
TrainName = (select name from b where id = a.Train)
from a
ScanName = (select name from b where id = a.scan) ,
TestName = (select name from b where id = a.Test) ,
TrainName = (select name from b where id = a.Train)
from a
insert @a select 12, 32, 32, 33
declare @b table(ID int, name varchar(10))
insert @b select 30, 'My'
insert @b select 31, 'you'
insert @b select 32, 'She'
insert @b select 33, 'He'
select a.id,b.name ,c.name,d.name from @a a inner join @b b on a.scan=b.id
inner join @b c on a.test=c.id
inner join @b d on a.train=d.id
/*id name name name
----------- ---------- ---------- ----------
12 She She He*/
insert into a values(12 , 32 , 32 , 33 )
create table b(ID int, name varchar(10))
insert into b values(30 , 'My')
insert into b values(31 , 'you')
insert into b values(32 , 'She')
insert into b values(33 , 'He')
goselect a.id,
ScanName = (select name from b where id = a.scan) ,
TestName = (select name from b where id = a.Test) ,
TrainName = (select name from b where id = a.Train)
from adrop table a,b/*
id ScanName TestName TrainName
----------- ---------- ---------- ----------
12 She She He(所影响的行数为 1 行)
*/
SELECT ID,
(SELECT NAME FROM TB WHERE ID=Scan) as ScanName,
(SELECT NAME FROM TB WHERE ID=Test) as TestName,
(SELECT NAME FROM TB WHERE ID=Train) as TrainName
FROM TA
inner join 表B b1 on a.scan= b1.id
inner join 表B b2 on a.Test = b2.id
inner join 表B b3 on a.Train = b3.id
testname=(select name from tb2 where id=t.test),
trainname=(select name from tb2 where id=t.train)
from tb1 t12 She She He