Inner join หลายตารางยังไงครับ มันทำไมมาเยอะยังนี้ครับ

$strSQL = "
SELECT * FROM (select * from personal where p_id=".intval($_GET['p_id']).") as per
,position pos, tbl_provinces prov, tbl_amphures amp, tbl_districts dist, tbl_zipcodes zip 
where (pos.position_id=per.position_id) 
and (prov.province_id=per.province_id) 
and (amp.amphur_id=per.amphur_id) 
and (dist.districts_id=per.districts_id) ##<<<<------ ขาดบันทัดนี้ 
and (zip.zipcode_id=per.zipcode_id)";
//หรือ แบบ admin
$strSQL = "
SELECT * FROM ( select * from personal where p_id=".($_GET['p_id']*1).") per
inner join position pos on pos.position_id=per.position_id
inner join tbl_provinces prov  on prov.province_id=per.province_id 
inner join tbl_amphures amp on amp.amphur_id=per.amphur_id
innter join tbl_districts dist on dist.districts_id=per.districts_id
innert join tbl_zipcodes zip on zip.zipcode_id=per.zipcode_id
";
//หรือ แบบ left join
$strSQL = "
SELECT * FROM ( select * from personal where p_id=".($_GET['p_id']*1).") per
left join position pos on pos.position_id=per.position_id
left join tbl_provinces prov  on prov.province_id=per.province_id 
left join tbl_amphures amp on amp.amphur_id=per.amphur_id
left join tbl_districts dist on dist.districts_id=per.districts_id
left join tbl_zipcodes zip on zip.zipcode_id=per.zipcode_id
";