100分求一条简单的SQL语句

[gwinner]

表TableA
Index Name Address
1 张三 北京市
2 李四 上海
3 王二 南京
4 赵六 纽约

表TableB
From To
1 2
1 3
2 4

需要一个SQL语句，执行后要求得到下面的表：
FromName ToName FromAddr ToAddr
张三 李四 北京 上海
张三 王二 北京 南京
李四 赵六 上海 纽约

也就是说，TableB的From和To列是和TableA的Index列绑定的。

[victorycyz]

select b.name as fromname,c.name as toname,b.address as fromaddr,c.address as toaddr
from tableB a left join tableA b on a.from=b.index
left join tableA c on a.to=b.index

[solidpanther]

select t1.Name as FromName,t3.name as ToName,t1.Address as FromAddr,t3.Address as ToAddr
from
tablea t1,tableb t2 ,tablea t3,tableb t4
where t1.index=t2.from and t3.index=t4.to and t2.from=t4.from

[zjcxc]

select FromName=b1.Name,ToName=b2.Name,FromAddr=b1.Address,ToAddr=b2.Address
from tableB a
left join tableA b1 on b1.[Index]=a.[From]
left join tableA b2 on b2.[Index]=a.[To]

[gwinner]

谢谢各位，我来试一下。

[tang]

select b.name as fromname,c.name as toname,b.address
as fromaddr,c.address as toaddr from tableb a
left join tablea b on a.[from]=b.[index]
left join tablea c on a.[to]=c.[index]

[tang]

select b.name as fromname,c.name as toname,b.address
as fromaddr,c.address as toaddr from tableb a,tablea b,tablea c
where a.[from]=b.[index] and a.[to]=c.[index]