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?