I have two tables, People (Name) and Books-People (ID, Name, Category, Title).
Name and Name are joined by a one to many relationship.
ID Name Category Title
1 John Math Geometry for dummies
2 John Math Engineering math
3 John Grammar The Grammar book
4 John Grammar Grammar and vocabulary
5 Marco Math Geometry for dummies
6 Bill Grammar Grammar and vocabulary
7 Marco Math Engineering math
I want a report that list people and book category related, i.e.
How can obtain this?