Ok I have tried it.
I adjusted the code, I do not get any errors, however I am still getting physical Products appearing if they are not NULL and are just blank example ''
Here is my code again:
SELECT siteezyecorders.*, siteezyecorderdetails.*, siteezyecproducts.*
FROM siteezyecorders INNER JOIN siteezyecorderdetails on siteezyecorders.OrderID = siteezyecorderdetails.DetailOrderID INNER JOIN siteezyecproducts on siteezyecorderdetails.DetailProductID = siteezyecproducts.ProductID
WHERE siteezyecorders.OrderUserID = paramUserID AND (siteezyecproducts.ProductLocation IS NOT NULL OR siteezyecproducts.ProductLocation != '')
GROUP BY siteezyecproducts.ProductLocation