inner join ( select min (cost) as cost, ResortID, DateofStay, DateSearched, RoomType from rates group by ResortID, DateofStay, DateSearched, RoomType ) as rr on r.cost = rr.cost and r.ResortID ...