Inner Join

select * from table1

inner join table2

inner join table3

       on table2.id=table3.id

       on table1.id=table3.id

where ...

order by