Access关联查询的问题!

[jsidiot]

table a
id user1 user2 user3 update .......
1 3 4 2
2 2 1 2
.
.
....


table b
userinfo

id name pwd update .....
1 ....aa
2 ....bb
3 .cc.
4 ... dd

想要这样的结果
a.id a.user1(b.name) a.user2(b.name) a.user3 a的其他数据
1 cc dd bb
1 bb aa bb

数据库是access
谢谢,

[cheny1234]

select a.id,b1.name,b2.name,b3.name from ((a inner join b b1 on a.user1=b1.id) inner join b b2 on a.user2=b2.id) inner join b b3 on a.user3=b3.id

[jsidiot]

好像有错误
select a.id,b1.name,b2.name,b3.name from ((table1 a inner join table2 b b1 on a.user1=b1.id) inner join b b2 on a.user2=b2.id) inner join b b3 on a.user3=b3.id

我是这么写的
好像有问题?

[cheny1234]

报什么错？

[jsidiot]

FROM 子句语法错误。

[jsidiot]

我的想法是这样的,
比如
select a.* from userinfo a
那么我如何再上面的语句里面使用userinfo 简化成a

[changechange]

select a.[id],b1.[name] as name1,b2.[name] as name2,b3.[name] as name3 from ((table1 as a inner b as b1 on a.[user1]=b1.[id]) inner join b as b2 on a.[user2]=b2.[id]) inner join b as b3 on a.[user3]=b3.[id]

Access中别名用 AS 表示。另外 SELECT 里面字段名一样的尽量声明别名

[jsidiot]

搞定
谢谢

[cheny1234]

和MSSQL搞混了，不好意思。

[jsidiot]

没关系,也谢谢你