List loans with LEFT JOIN

List every member and their loans with LEFT JOIN.

Loaned books

To match loaned books with members you use LEFT JOIN. Books never loaned come as NULL.

SELECT b.title, l.loan_date
FROM books b
LEFT JOIN loans l ON l.book_id = b.id;

This query lists all books with their loan records.

b.title, l.loan_date is selected from books b. loans l is joined on l.book_id = b.id, keeping every row of the left table.

LEFT JOIN keeps every book; with no loan record, loan_date becomes NULL.

This way you see every book; a filled loan_date means it is on loan, and NULL means it is on the shelf.

LEFT JOIN all books with the loans table.

Show example solution

SELECT b.title, l.loan_date
FROM books b
LEFT JOIN loans l ON l.book_id = b.id;

Add LEFT JOIN

SELECT b.title, l.loan_date
FROM books b
____ loans l ON l.book_id = b.id;

Show answer

SELECT b.title, l.loan_date
FROM books b
LEFT JOIN loans l ON l.book_id = b.id;