Update with subselect

[Ben Hood]

Hi,

I can't seem to find any documentation about how to use a subselect in an update statement, e.g.

update t1 set c = (

  select t2.a

  from t2

  where t2.id = t1.t2_id

)

Am I missing something here?

Cheers,

Ben

[Lukas Eder]

Hi Ben,

See this previous discussion here:
https://groups.google.com/d/topic/jooq-user/K8CsrheoFlk/discussion

Cheers
Lukas

2012/8/29 Ben Hood <0x6e...@gmail.com>:

[Ben Hood]

Hi Lukas,

On Wednesday, 29 August 2012 15:14:14 UTC+1, Lukas Eder wrote:

Hi Ben,

See this previous discussion here:
https://groups.google.com/d/topic/jooq-user/K8CsrheoFlk/discussion

Ah yes, don't you just love user group members who can't even google their own questions they've asked in the past - I guess I'm getting forgetful in my old age :-)

Sorry for the bother.......

Cheers,

Ben 

[Lukas Eder]

> Ah yes, don't you just love user group members who can't even google their
> own questions they've asked in the past - I guess I'm getting forgetful in
> my old age :-)

I was just thinking, maybe this is yet another Ben Hood ;-)

Cheers
Lukas