Member summary

Write a mixed report with FULL JOIN.

To see the full loan history of members you use FULL OUTER JOIN. Members with no loans also appear.

SELECT m.name, l.book_id
FROM members m
FULL OUTER JOIN loans l ON l.member_id = m.id;

This query lists all members and loans.

m.name, l.book_id is selected from members m. loans l is joined on l.member_id = m.id, keeping every row of both tables.

Member summary — details

FULL OUTER JOIN keeps both sides. Unmatched members and loans come as NULL.

This way one report shows both members who never borrowed a book and faulty loan records without a member.

Join members with loans using FULL OUTER JOIN.

Show example solution

SELECT m.name, l.book_id
FROM members m
FULL OUTER JOIN loans l ON l.member_id = m.id;

Add FULL OUTER JOIN

SELECT m.name, l.book_id
FROM members m
____ loans l ON l.member_id = m.id;

Show answer

SELECT m.name, l.book_id
FROM members m
FULL OUTER JOIN loans l ON l.member_id = m.id;