ASP.NET / VB / MS SQL: Implement Complex SQL Queries

I have a website that is powered by ASP.NET / Visual Basic and Microsoft SQL. The website is working except for one page that requires several very complicated SQL queries. Results are not grouped correctly. For example, a building may have 20 "One Bedroom" units and 10 "Two Bedroom" units. There are 30 total units but only 2 types. Only the two types should be displayed on my webpage like this: --------------------------------------------- Unit Type: One Bedroom Rent: $100 - $200 Size: 500 Square Feet up to 900 Square Feet Availability: Yes --------------------------------------------- Unit Type: Two Bedroom Rent: $200 - $300 Size: 700 Square Feet up to 950 Square Feet Availability: No --------------------------------------------- However because the SQL query is not grouped correctly, I get 30 results instead of 2.