I've looked through your documentation and don't see how to use Query Builder to update one table using data from another table. Does this involve joining the two tables in a subquery?
I can write update queries that run in an editor tab, but when I copy them back to the Query Builder SQL tab, Toad says they cannot be modeled. The dropdown for Statement Type includes Update Statement, but what CAN you do with Update Statements in Query Builder.
I don't think I even see how to update one column setting the values to be equal to another column in the same table (a single table Update Query).
To understand this I created a small test table. To update Column2 to "hello" where Column1 = 3 you enable binding variables from the SQL query --- the (x)= icon on the tool bar. Query builder creates the following and it works.
SET COL2 = :COL2
WHERE (TEST_TOAD.COL1 = '3')
But that is for manual entry.
What about something simple, like setting column3 in a table equal to columnn1 based on a where statement.
Do you have any examples in your documentation of using Query Builder and Update Statements?
I have looked at the training videos, but they concentrate on select statements.
I'm aware that these Update queries can only have one table in the top diagram.