On Tue, Apr 28, 2015 at 1:24 PM, Lukas Eder <[email protected]> wrote: > Hmm, no, that syntax isn't supported (yet). Perhaps we might add support in > the next version. It should be rather simple to emulate: > https://github.com/jOOQ/jOOQ/issues/4245 > > In the meantime, you'll need to resort to a classic semi-join using IN or > EXISTS: > > DELETE FROM pending_invites i > WHERE i.registrant = ? > AND i.msisdn IN (SELECT u.msisdn FROM users u WHERE u.id = ?);
Many thanks for the heads up. Using the semi-join variant is fine for me - I appreciate the USING syntax is just syntactic sugar. I was just doing some naive statement by statement porting of a native SQL app to JOOQ when I came across this example. Thanks for your help. -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
