The Multi-Table Query Generator - Mastering phpMyAdmin 2.11 for Effective MySQL Management - page 210

Automatic Joins
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.
There may be more than two tables involved in a join.
Executing the Query
Clicking the Submit Query button sends the query for execution. In phpMyAdmin
version 2.11.0, there is no easy way (except by using the browser's Back button) to
come back to the query generation page after we have submitted our query. The next
chapter ( Bookmarks ) discusses how to save the generated query for later execution.