select A.HotelID,A.Title ,B.price from A a left join (select HotelID,min(price) as price from B group by HotelID) b on a.HotelID=b.HotelID
