select table1.*, table2.*, table3.*, ..., tablen.* from table1
inner join table2 on (table1.zzz=table2.zzz)
inner join table3 on (table1.zzz=table3.zzz)
...
inner join tablen on (table1.zzz=tablen.zzz) where table1.zzz = 13;