Help joining tables

[lalov1]

I have four different tables called residential, commercial, multi_family, and land. They all have images stored in an images table. The following works for the residential table just like I want:

SELECT * FROM `residential` INNER JOIN `images` as i on i.mls = residential.mls WHERE i.photoOrder = 0

 

Would I be able to join all four tables to the images table? I'm new to all this and didn't set-up the structure.

 

Thank you,

Lallo

[andrewgauger]

You want to define which table you are getting * from (even better is to define every field you want)

 

such as:

 

SELECT residential.* FROM `residential` INNER JOIN `images` as i on i.mls = residential.mls WHERE i.photoOrder = 0

 

And yes this should work with the other tables.  The ON syntax is where you need to modify depending on the table columns