三表连接查询（在线等）急求

[snihcel]

t1 01,02,03
t2 01,11
t3 01,13


这样查为什么不对急求
SELECT *
FROM t1
left join t2 ON t1.[01] = t2.[01]
left join t3 ON t1.[01] = t3.[01]

[wym840713]

不能用01,02,03作为列名,换成字母就可以了
比如:
SELECT *
FROM t1
left join t2 ON t1.a = t2.a
left join t3 ON t1.a = t3.a

[caixia615]

t1.后面跟的应该是字段名..

[snihcel]

SELECT *
FROM (SELECT A.[01] as KeyID
FROM t1 AS A LEFT JOIN t2 AS B ON A.[01]= B.[01]) AS D LEFT JOIN t3 AS C ON D.[keyID]=C.[01]

[snihcel]

但这上面这一个就可以执行
我快晕了，
上帝啊，

[marco08]

--这样


create table t1([01] int, [02] int, [03] int)
insert t1 select 1,2,3
insert t1 select 2,3,4

create table t2([01] int, [11] int)
insert t2 select 1, 11

create table t3([01] int, [13] int)
insert t3 select 2, 21

select * from t1
left join t2 on t1.[01]=t2.[01]
left join t3 on t1.[01]=t3.[01]

--result
01 02 03 01 11 01 13
----------- ----------- ----------- ----------- ----------- ----------- -----------
1 2 3 1 11 NULL NULL
2 3 4 NULL NULL 2 21

(2 row(s) affected)

[snihcel]

兄弟你用的是SQL吧，我用accsse，这个段脚本查不了，

[marco08]

有SQL2000

[hui_hui_2007]

字段是数字打头的。好象要用[]括起来吧。记不清了。