多表查询问题(在线等)

[liaoxiaohua1981]

有三张表
BInfo
ID State Type SCode
1 1 2 3
2 2 1 5

SInfo
ID State Dcode
1 1 正常
2 2 暂停


TInfo
ID Type Dcode
1 1 Web
2 2 Ftp

要求用一条语句查询出结果
SCode StateName TypeName
3 正常 Ftp
5 暂停 Web

[liangCK]

SELECT A.SCode,B.DCode AS StateName,C.DCode AS TypeName
FROM BInfo AS A
    JOIN SInfo AS B
ON A.State = B.State
    JOIN TInfo AS C
ON A.Type=C.Type

[olddown]

select a.SCode, b.Dcode as StateName, c.Dcode as TypeName 
from BInfo a,SInfo b,TInfo c
where a.ID=b.ID and a.ID=c.ID

[百年树人]

select 
  a.scode,
  b.dcode as statename,
  c.dcode as typename
from
  binfo a,
  sinfo b,
  tinfo c
where
  a.state=b.state
and
  a.type=c.type