access的多于两个表的数据查询的sql语句怎么写？

select * from a left join b on a.id=b.a_id left join c on b.id=c.b_id
3个表了

select a.studentname,a.zhengpic,b.getbookdate from studentinfo as a ,bookinfo as b ,booktype as c on a.id=b.studentid and b.id=c.id本回答被提问者采纳

select a.studentname,a.zhengpic,b.getbookdate
from studentinfo a and bookinfo b
if a.id=b.studentid

多join 连接就行了..