--查询所有图书的书名,作者名,出版社名称(多表内连接)
use booksmanager --打开数据库
select bookname as 图书名称,authorname as 作者名称,c.publishername as 出版社名称
from (books b inner join authors a --inner join 为关键字,将两个表连在一起
on b.authorid=a.authorid) inner join publisher c
on b.publisherid=c.publisherid