一道数据库题

ahao214 发布于 2010-11-20 10:44， 555 次点击

请教一个问题
第一张表t1
id no1 no2
1   1   2
2    2   1
3   3   3
第二张表t2
id  name
1    a
2    b
3    c
第二张表的id和第一张表的no1，no2是主外键关系
查询得到第三张表
id no1 name no2 name
1   1   a   2    b
2   2   b   1    a
3   3   c   3    c

3 回复

南川2010-11-20 11:13

select t1.id,t1.no1,t2.[name],t1.no2,t3.[name]
from t1 left join t2
on t1.no1=t2.id left join t2 as t3
on t1.no2=t3.id

rdsc20062010-12-01 14:38

SELECT t1.id AS id,
(SELECT t1.no1) AS no1,
(SELECT name FROM t2 WHERE id=t1.no1) AS id1,
(SELECT t1.no2) AS no2,
(SELECT name FROM t2 WHERE id=t1.no2) AS id2
FROM t1

kanongwei2010-12-01 17:01

第三方