Phone 949-297-8844
Fax 949-297-8848
20902 Bake Pkwy., Suite 106
Lake Forest, CA 92630

Email Marketing
SELECT Top 1 products.idProduct AS idProd, Max(discountsPerQuantity.num) AS maxBracketCount FROM (products INNER JOIN (categories INNER JOIN categories_products ON categories.idCategory = categories_products.idCategory) ON products.idProduct = categories_products.idProduct) LEFT JOIN discountsPerQuantity ON products.idProduct = discountsPerQuantity.idproduct GROUP BY categories.idCategory, products.idProduct HAVING categories.idCategory=1386 ORDER BY Max(discountsPerQuantity.num) DESC; ...3021error in DB read rsMaxBrackets