Jump to content

Help joining tables


lalov1

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/202794-help-joining-tables/
Share on other sites

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

Link to comment
https://forums.phpfreaks.com/topic/202794-help-joining-tables/#findComment-1063284
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.