How are the columns named in the database? The Dynamic dropdowns extension just looks at what the name is in the database, not the name in the SQL statement.
SQL is not as case sensitive as PHP is.
So if the name in the database is ID
SELECT id will still work.
but the php code will need to use the SQL case, not the database case.