Subquery returning tuple? where (a, b) not in (select c, d from ...)

[dimgel]

Hello all. How can I do subj?

Something like .where(new QTuple(t1.a, t1.b).notIn(new SQLSubQuery().from(t2).list(t2.c, t2.d))), although this does not compile: QTuple have no notIn() method.

Thanks.

[timowest]

You can use ExpressionUtils.notIn for the NOT IN operation.

[dimgel]

Thank you. But there's a error in generated SQL: no braces around tuple: where a, b in (select c, d from ...). Is there anyway to workaround?

[timowest]

QTuple are meant for result definition and post processing.

If you need a list you can use Expressions.list(...).in(new SQLSubQuery()...)

[dimgel]

Thank you very much, that did it! =)