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

Adjusting the number of criteria columns
Using a similar mechanism, we can add or delete columns by checking the Ins or Del
checkboxes under each column in the Modify dialog, or the Add/Delete columns
dialog. We already had one unused column (not shown on the previous images).
Here, we have added one column using the Ins checkbox located under the unused
column (this time, we will need it):
Generating automatic joins (internal
relations)
phpMyAdmin can generate the joins between the tables in the query it builds,
provided internal relations have been defined. Let us now populate our two unused
columns with the title and the genre columns from our book table, and see what
happens when we update the query.