Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

#1109 - Unknown table 'c' in field list

Status
Not open for further replies.

shop73

IS-IT--Management
May 13, 2007
48
BA
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

 
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.
 
This is the truth! I rename "C" in "c" in recordset and this works correctly.

Thank You Chris!

You are the best!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top