update from another table
Posted: Wed Jun 27, 2001 3:51 pm
Is it possible to set a field in one table to be equal to another field in another table using an update statement?
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);