Quilmes Posted August 17, 2007 Share Posted August 17, 2007 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.