#1109 - Unknown table 'c' in field list

[shop73]

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

 

[ChrisHirst]

Aliases can be case sensitive depending on the platform


Windows platforms which no doubt your "localhost" is, are not case sensitive, but *nix platforms which your production server probably is are case sensitive so "C" and "c" are NOT the same.


Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[shop73]

This is the truth! I rename "C" in "c" in recordset and this works correctly.

Thank You Chris!

You are the best!!!