Hi,
I'm doing a subquery to select the top 5 of products for each supplier. The selection needs to be done randomly on the products for each supplier.
For this I have made the following query (based on Allen Browne's example):
SELECT tblProducts_temp.SupplierID, tblProducts_temp.GTIN
FROM...