How to join 4or 5 tables?

Question

How to join more tables in mysql using any join

Answer 1

I'd use multiple inner joins but that depends on what data you want, for example :

Select * from table 1 as t1
Join table 2 t2 on t1.id = t2.id
.....
Join table 6 t6 on t5.id = t6.id

This will join all above tables into one single temporary table.

Answer 2

Thanks..