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.

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.

Note

There may be more than two tables involved in a join.