MySQL显示多个表中的列

Question

我有两个表:图书和出版商

图书列为:book_code、title、publisher_code

发布商列为:publisher_code、publisher_name

我正在尝试显示每本书的书名及其 book_code、publisher_code 和publisher_name

到目前为止，这就是我所拥有的:

select book_code, title, a.publisher_code
from book a
inner join publisher p
on a.publisher_code = p.publisher_code;

我不确定如何显示publisher_name

Answer 1

在 mysql 中，我会这样写:

SELECT
  b.book_code,
  b.title,
  b.publisher_code,
  p.publisher_name
FROM
  book AS b
    JOIN publisher AS p USING (publisher_code);