update from another table

[sourceuno]

Is it possible to set a field in one table to be equal to another field in another table using an update statement?

[John]

Yes, there are two ways you could do it. The simplest is using Vortex, and select the value first, and then do the update. You can also use a subquery in the update, for example:

update test set y = (select j from test2 where test2.i = test.x);