I'm encountering the above error when using inner queries. I don't know if it's related but when using standard queries with no inner queries and table name references the query works fine. To ensure that there is nothing wrong with my queries these were also tested on DBeaver with positive results.
Can anyone help on how I can remove this error when querying from ODBC