Re: Nested SELECT in UPDATE statement

[Ben Hood]

Hi Lukas,

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()) 
>

Thanks for such a quick response to my question :-)

I hadn't seen the asField() operator, so I'll give that a go now.

Cheers,

Ben