Want to update a table record (computer) where computer_name match a record in another table (flowbot) where computer_name is a foreign key. I can make the inner join function and update function work separately. Can't figure out how to combine them. Get this error: could not determine data type o…

:thinking: Interesting! Well, I'm glad it's working :pray:

Can't combine sql update with join

Tess January 17, 2024, 3:58pm 4

Interesting! Well, I'm glad it's working

Topic		Replies	Views
Insert/Update for Retool database table does not work in SQL mode 💬 Queries and Resources sql , table , postgresql	7	2710	June 21, 2023
Disabling Prepared Statements in Retool Database 💬 Queries and Resources	22	124	January 17, 2025
Best practice - duplicating a header + detail set of records 💬 App Building	15	823	August 3, 2023
Update based on selectedRow id? 💬 Queries and Resources	8	2162	August 1, 2023
Unable to update sql table via form 💬 App Building table , component	2	769	March 19, 2024