The Multi-Table Query Generator - Mastering phpMyAdmin 3.1 for Effective MySQL Management - page 204

• The query area

• Buttons to update or to execute the query

Choosing tables
The initial selection includes all tables. In this example, we assume that the
linked-table infrastructure has been installed in the marc_book database. (See the
section, Single-user installation , in Chapter 11.) Consequently, the Field selector
contains a great number of fields. For our example, we will work only with the author
and the book tables. Hence, we select only these from the Use Tables selector.

We then click on Update Query . This refreshes the screen and reduces the number of
fields available in the Field selector. We can always change the selected tables later,
using our browser's mechanism for multiple choices in drop-down menus (usually
control-click).