多个Access数据库文件的联合查询问题

[dpjing]

A,B,C是3个相同结构但存有不同年份资料的Access数据库文件，我现在要查出这3个库中t_user表中都存在的user记录

[zhengjialon]

用联合查询。

[changechange]

用union all 查询，结合用in子句或链接表就可以了

[zjcxc]

select * from
(select * from t_user1 uoion all select * from t_user2 union all select * from t_user3)
where user in(select user from t_user1)
and user in(select user from t_user2)
and user in(select user from t_user3)

[zjcxc]

上面的错了,你是分三个库,而不是三个表,所以应该用,注意将c:换成你的数据库所在的目录:

select * from
(select * from [;DATABASE=c:\A.mdb].[t_user] uoion all select * from [;DATABASE=c:\B.mdb].[t_user] union all select * from [;DATABASE=c:\C.mdb].[t_user])
where user in(select user [;DATABASE=c:\A.mdb].[t_user])
and user in(select user from [;DATABASE=c:\B.mdb].[t_user])
and user in(select user from [;DATABASE=c:\C.mdb].[t_user])