Jump to content

Multiple Table Search


Quilmes

Recommended Posts

Alright, I've been playing around with this and I can't quite find the right answer.  I have two tables.  One has a list of apartments with each having an id.  The other has a list of the apartment's bedroom configurations, each one starts with the same id of the apartment.  Now I'm using LEFT OUTER JOIN to get all of the apartments and their configuration.  But now I get a list of every apartment, plus each of it's configurations.  What I want is just the list of the apartment itself.  Instead of the results coming back with 6 of one apartment, I just want it to show me the apartment once... Anyone? 

Link to comment
https://forums.phpfreaks.com/topic/65477-multiple-table-search/
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.