Retool Database Join query returns 400 error without details

💬 App Building
1

Hi,

I'm using Retool Database, I have 2 tables :

  • SKU
  • Appellation

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:

Capture d’écran 2023-05-16 à 21.42.58
Capture d’écran 2023-05-16 à 21.42.582078×594 46.2 KB

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
Brieuc

2

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

2 Likes
3

Hi @Brieuc_Lambert

This same syntax is working in my app :thinking:

Are any queries working for your Retool db? (for example, SELECT * FROM sku limit 1)

4

Thanks @27shutterclicks, specifying sku.id worked :ok_hand:
I didn't find any details in the view state tab of the query though.

thanks!

1 Like