multiple SELECT queries or JOIN()

[Jin]

Hi,
I have some questions regarding getting results from multiple tables in a single DB using MySQL.

For example, I have 2 drop down menus

---

| Choose Property | V |

---

---

| Choose Location | V |

---

---

| Go |

---

Would using a join query instead of using multiple select query be better as in more easier to read the code and more efficient?
This is because I find that using multiple select query is really confusing as I have more than 2 relational tables. What will be a more appropriate approach to tackle this kind of situation.

Thanks

[coppercoins]

Make the DB do the work in the query - in other words, get all the information you need in as few queries as possible. Joins and subqueries are nice to have around.