Books and authors

Write the INNER JOIN query for books and authors.

Book and author

To list books with their authors you use INNER JOIN. author_id connects the two tables.

SELECT b.title, a.name
FROM books b
INNER JOIN authors a ON b.author_id = a.id;

This query matches book and author names.

b.title, a.name is selected from books b. authors a is joined on b.author_id = a.id, keeping only matching rows.

Book and author — details

Each book should have an author. Unmatched books drop out.

books JOIN authors ON books.author_id = authors.id puts the author's name next to each book; because it is an INNER JOIN, a book with no registered author is left out.

Exercise Book and author

INNER JOIN books with authors; select title and name.

Show example solution

SELECT b.title, a.name
FROM books b
INNER JOIN authors a ON b.author_id = a.id;

Test yourself

Add INNER JOIN

SELECT b.title, a.name
FROM books b
____ authors a ON b.author_id = a.id;

Show answer

SELECT b.title, a.name
FROM books b
INNER JOIN authors a ON b.author_id = a.id;

Which JOIN for book-author match?
- CROSS JOIN
- UNION
- INNER JOIN
- LEFT JOIN
Show answer

INNER JOIN — INNER JOIN fits matching pairs.
Books and authors: match the terms

books

book
authors

author
author_id

link
INNER JOIN

intersection

Next lesson: List loans with LEFT JOIN

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies