Join Three or More Tables

two tables and one join type in the from clause, and a single on subclause to define how tables are joined.

SELECT $aliases.field...
FROM $table1 $aliases1
  INNER JOIN $table2 $aliases2
    ON $aliases1.field = $aliases2.field
  INNER JOIN $table3 $aliases3
   ON $aliases1.field = $aliases3.field;