Hi rmiao,

If i do what you're suggesting then i get all the results back which isn't what i want. I only want the lowest priced item from the Merchant_Products table which relates to the Product_ID in the Products table.

Thanks again for your help.

Sach