SQL高手请了：这样的SQL语句应该怎么写？（200分送上）(200分)

V

vc3000

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-05

• #1

有如下所示三个表（SQL Server数据库）：
Table1:ID,Name,T2_ID,T3_ID;
Table2:ID,Name;
Table3:ID,Name;
SQL语句如何写，才能得到如下数据集：
ID,Name,T2_Name,T3_Name;

 

S

seago

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-05

• #2

SELECT T1.ID,T1.Name,T2.Name,T3.Name
FROM Table1 T1,Table2 T2,Table3 T3
WHERE T1.T2_ID=T2.ID AND T1.T3_ID=T3.ID

 

L

linglingx

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-05

• #3

SELECT T1.ID,T1.Name,T2.Name,T3.Name
FROM Table1 T1,Table2 T2,Table3 T3
WHERE T1.T2_ID=T2.ID AND T1.T3_ID=T3.ID
一点不错，完全同意楼上的

 

Z

zhangkan

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-05

• #4

select a.ID,a.Name,b.Name as T2_Name,c.Name as T3_Name
from Table1 a,table2 b,table3 c
where a.ID=b.ID(+) and a.ID=c.ID(+);

 

V

vc3000

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-05

• #5

[]thx.

 

V

vc3000

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-05

• #6

[]sorry zhangkan,我给分的时候你还没有贴上呢。