Balbin0#8695242
Balbin0#86952425mo ago

Balbin0#9613123 - Guys, there's a way to add a ...

Guys, there's a way to add a Node, where I can make the join with the id's columns? I'm using chat with supabase
Solution:
Hi @Balbin0#9613123, You can use the Join Query Read the specified columns of a Supabase table and join with another table using ID columns. Example: select=${selectColumns},${joinTable}(${joinTableID});` official docs for join query syntax - link. ...
Supabase
Querying Joins and Nested tables | Supabase Docs
The Data APIs automatically detect relationships between Postgres tables.
No description
Jump to solution
2 Replies
Solution
Gaurav Chadha
Gaurav Chadha5mo ago
Hi @Balbin0#9613123, You can use the Join Query Read the specified columns of a Supabase table and join with another table using ID columns. Example: select=${selectColumns},${joinTable}(${joinTableID});` official docs for join query syntax - link. You can easily implement and achieve this by modifying the existing "Get Columns" node using AI.
Supabase
Querying Joins and Nested tables | Supabase Docs
The Data APIs automatically detect relationships between Postgres tables.
No description
Balbin0#8695242
Balbin0#86952425mo ago
Perfect, thanks for sharing your knowledge with me!