SQL 数据库将多个表连在一起

2019独角兽企业重金招聘Python工程师标准>>>

--查询所有图书的书名,作者名,出版社名称(多表内连接)

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

 

转载于:https://my.oschina.net/u/3820352/blog/1818425