Why is a JOIN needed to produce a report containing both book titles and author names?
JOIN writes query output directly to a project file.
Both values are already stored in every row of the books table.
The values are stored in separate related tables and must be combined through their author relationship.
JOIN is used only to sort publication years.