On Thursday, July 12, 2012 1:12:20 PM UTC+1, Ben Hood wrote: > > On Thursday, July 12, 2012 1:02:29 PM UTC+1, Lukas Eder wrote: >> >> Essentially, you can achieve this as such: >> create.update(TABLE) >> .set(COLUMN, create.select(something).from(somewhere).asField()) > > One thing I forgot to ask was what it would look like when you want to update more than 1 column with the same select statement, e.g.
UPDATE Table SET col1, col2 SELECT something, something_else FROM somewhere ?
