Generating Multi-table Queries - Mastering phpMyAdmin 3.4 for Effective MySQL Management - page 219

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 preceding screenshot) on the author_id key column. A shortcoming of the
current version is that only the internal relations, and not the InnoDB relations,
are examined.
There may be more than two tables involved in a join.
Executing the query
Clicking on the Submit Query button sends the query for execution. In the following
screenshot, you can see the complete generated query in the upper part, and the
resulting data row in the lower part:
There is no easy way (except by using the browser's Back button) to come back to the
query generation page once we have submitted the query. Chapter 14 discusses how
to save the generated query for later execution.