Fileds name uppercase

[isysoftware]

Hi All,
I have this simple query for a MySql database:
Select distinct Anno From aperture where Aperto=1 order by id desc
My application has been installed on a Windows machine and I haven't had any problems.
Now, I have my application on a Virtual Machine on Mac and I want to connect to MySql installed on Mac. I have an error when this query is executed: error is on id field of the order clause; the id field in table is named ID (all uppercase).
There's a way to solve this kind of problems? Or I need to check all my fields?
Thanks.

[ViktorV]

Please specify the exact error message and the MySQL version you are using.
Also provide the result of the following query:

Code: Select all

SHOW VARIABLES LIKE 'lower%';