I have updated the Recordset from:
SELECT orders.*, orderdetails.*, products.*
FROM orders INNER JOIN orderdetails on orders.OrderID = orderdetails.DetailOrderID INNER JOIN products on orderdetails.DetailProductID = products.ProductID
WHERE orders.OrderUserID = paramUserID AND products.ProductLocation IS NOT NULL
GROUP BY products.ProductLocation
To:
SELECT orders.*, orderdetails.*, products.*, productfiles.*
FROM orders INNER JOIN orderdetails on orders.OrderID = orderdetails.DetailOrderID INNER JOIN products on orderdetails.DetailProductID = products.ProductID INNER JOIN products on products.ProductID = productsfiles.ProductFileID
WHERE orders.OrderUserID = paramUserID AND productfiles.productFile_DowloadName IS NOT NULL
GROUP BY productfiles.productFile_DowloadName
and now I am getting this error:
Not unique table/alias: 'products'
Am I missing something?
