Example:
// Assuming import static org.jooq.impl.DSL.*;
using(configuration)
.select()
.from(CUSTOMER)
.where(row(CUSTOMER.FIRST_NAME, CUSTOMER.LAST_NAME).eq(any(
select(ACTOR.FIRST_NAME, ACTOR.LAST_NAME).from(ACTOR)
)))
.fetch();
Instances can be created using DSL#any(Select) and
DSL#all(Select).