Re: Help With Advanced Query

[Peter Brawley]

> 1 Listing Per Hotel, Per Airport, Per Day

You failed to say on what criterion. Supposing it's minimum price, you could write something like ...

select a.*
from search_results a
join (
  select datecol, airportcol, hotelcol, min(price) as theprice
  from search_results
  where priceperadult ... etc ...
  group by datecol, airportcol, hotelcol
) as b on a.datecol=b.datecol 
       and a.airportcol=b.airportcol 
       and a.hotelcol=b.hotelcol
       and a.price=b.theprice;

substituting correct column names.