************ ошибка ***********
SQL ERROR..... N1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY Brand.Name' at line 1SELECT Product.IsActive, Product.BrandId, Product.ProductId, Brand.Name AS BrandName FROM Brand LEFT JOIN Product ON Brand.BrandId = Product.BrandId LEFT JOIN Category ON Product.CategoryId = Category.CategoryId WHERE Product.IsActive=1 AND Brand.IsActive=1 AND Product.CategoryId = ORDER BY Brand.Name
|