phpMyAdmin can generate the joins between tables in the query it builds. Let's now populate our two unused columns with the title and genre fields from our book table and see what happens when we update the query:

phpMyAdmin used its knowledge of the relations defined between the tables to generate a left join on the author_id key field. A shortcoming of the current version is that only the internal relations are examined, not the InnoDB relations.