I'm using Retool Database, I have 2 tables :
Appellation is referenced by the sku table in the sku.appellation column.
When querying the retool database and trying to join sku with appellation to get appellation data into the final result I always face this error:
My request seems correct, and the error is really helpful.
Any idea what the idea means or how to fix the query?
thanks in advance
I had this issue before, but I cannot reproduce it now. If you "View State" of the query, there may be additional details there in one of the keys.
To fix the error, you may want to specify a table for the id you order by:
.. ORDER BY sku.id DESC
May 17, 2023, 12:03am
This same syntax is working in my app
Are any queries working for your Retool db? (for example, SELECT * FROM sku limit 1)
@27shutterclicks, specifying sku.id worked
I didn't find any details in the view state tab of the query though.