How to join multiple tables?

Databases
1

how to inner join with multiple tables in mysql…

2 

SELECT
  ...
FROM ...
INNER JOIN ...
ON ...
INNER JOIN ...
ON...
ecc.
3 

SELECT tbl1.a_field, tbl2.another_field, tbl3.yet_another_field FROM
    table1 AS tbl1
    INNER JOIN table2 AS tbl2 ON (tbl1.id=tbl2.id)
    INNER JOIN table3 AS tbl3 ON (tbl2.id=tbl3.id)

Is that what you mean?