filter one rs with another

i am trying to filter one record set with another.

recordset 1:
SELECT merchant_inv.hotel_id, merchant_inv.name, merchant_inv.low_rate, merchant_inv.high_rate, merchant_inv.star_rating
FROM merchant_inv
WHERE merchant_inv.city LIKE 'New York%' and merchant_inv.state_province = 'NY' AND merchant_inv.high_rate <= '200' AND merchant_inv.star_rating = '3.0'

recordset 2:
SELECT images.thumbnail_url
FROM images
WHERE images.hotel_id='myHotelId'

myHotelId = $row_rsFeaturedHotels['hotel_id']

however, in my repeat region the filter only matches the first record in rs2 resulting in the same image being repeated for each record in rs1