Recent content by thalassa3000

It is the random top 5 of products in the assortment of a supplier. So say if a supplier has 19 products in it's assortment, I want to select 5 random products for the supplier. The needs to be done for each supplier (supplierID) and it's products (productid), which are store in the table...

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...