Hello,
I try use this query in localhost (XAMPP) and hi work,
<code>SELECT C.categoryName, Count(P.prodname) as prodcount, c.categoryID FROM categories as C left join products as P on p.categoryID = c.categoryID WHERE P.prodShow = 'Y' GROUP BY c.categoryName</code>
but when I put this code in my server he don't work.
Error: #1109 - Unknown table 'c' in field list
I try use this query in localhost (XAMPP) and hi work,
<code>SELECT C.categoryName, Count(P.prodname) as prodcount, c.categoryID FROM categories as C left join products as P on p.categoryID = c.categoryID WHERE P.prodShow = 'Y' GROUP BY c.categoryName</code>
but when I put this code in my server he don't work.
Error: #1109 - Unknown table 'c' in field list