lalov1 Posted May 25, 2010 Share Posted May 25, 2010 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 More sharing options...
andrewgauger Posted May 25, 2010 Share Posted May 25, 2010 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.