ADO+Access在两表之间连接查询

[wangzhjsz]

现有：
班级表t_clazz(主键id，班级名称),
学生表t_student（主键id，学生姓名，所属班级id）；
表结构如下：
=======================================================
t_clazz（id,clazz_name）
t_student(id,student_name,t_clazz_id)
========================================================
现要查询的结果如下
id student_name clazz_name

========================================================
mysql的sql语句参考：
select s.id aaa, s.student_name bbb , c.clazz_name ccc
from t_clazz c, t_student s
where s.t_clazz_id = c.id ;
========================================================
access数据库的语句不知道该怎么写？

[不说害怕]

SELECT s.id s.student_name c.clazz_name
FROM t_student AS s INNER JOIN t_clazz AS c ON s.t_clazz_id = c.id;

[xgia7]

SELECT B.id as aa, B.name as bb, A.clazz_name as cc
FROM t_clazz as A
left join t_student as B on A.id = B.t_clazz_id

[xgia7]

SELECT B.id as aa, B.student_name as bb, A.clazz_name as cc
FROM t_clazz as A
left join t_student as B on A.id = B.t_clazz_id

[zyq5945]

ACCESS不支持空格的别名方式，要加AS给它取别名。

[jxufeng]

还可以两个 mdb文件间连接查询