现有:
班级表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数据库的语句不知道该怎么写?
班级表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数据库的语句不知道该怎么写?
FROM t_student AS s INNER JOIN t_clazz AS c ON s.t_clazz_id = c.id;
FROM t_clazz as A
left join t_student as B on A.id = B.t_clazz_id
FROM t_clazz as A
left join t_student as B on A.id = B.t_clazz_id