phpMyAdmin can generate the joins between the tables in the query it builds. Let's now populate our two unused columns with the
title and the
genre fields from our book table, and see what happens when we update the query.
There are now two additional criteria columns that relate to the `book `.`title` and the `book`.`genre` columns respectively. phpMyAdmin used its knowledge of the relations defined between the tables to generate a
LEFT JOIN clause (highlighted in the previous figure) on the author_id key field. A shortcoming of the current version is that only the internal relations, and not the InnoDB relations, are examined.