How do I join multiple tables in a mysql query?

SELECT [column fields that you want to retrieve] FROM table1 INNER JOIN table2 ON table1.primarykey = table2.foreignkey INNER JOIN table3 ON table2.primarykey = table3.foreignkey INNER JOIN table4 ON table3.primarykey = table4.foreignkey INNER JOIN table5 ON table4.primarykey = table5.foreignkey WHERE field = yourcriteria you can continue on. primary key is the first table's key and foreign key is the reference field if you want to get records with no matching records from other table you use an OUTER JOIN LEFT OUTER JOIN table6 ON table5.primarykey = table6.foreignkey you get the idea. ;)

innerjoin on mobilehome IDs

You might be over complicating it. I'll skip some basics since you seem to be connecting fine already. I don't know all of your field names or true table names so I'll use these: 4sale, parks, repos A query would look something like this...(it is best if they share a common field like "id") SELECT * (replace with actual field names example: repos.address, 4sale.price, parks.city) FROM 4sale, parks, repos WHERE (insert your conditions here example: parks.city = $_POST['city'] ect...){assuming you're gathering the info from a form} You can also add different SELECT commands using the UNION or UNION ALL command. (use the union all if you have fields that will contain the same value. this will allow the duplicates to show) This would look like: SELECT * FROM 4sale UNION SELECT * FROM repos UNION SELECT * FROM parks Good luck, hope that helps. Feel free to update your question or send an e-mail if you get stuck!