Convert SQL into JOOQ query

25 Views Asked by At

What is the JOOQ equivelent of the below query?

SELECT e."e_request_id", e."e_participant_id"
FROM "e_request_participation" e
         JOIN (SELECT unnest(array ['clh9omw2o00000134toygpm7o', 'clh5gs4rb0000wy34v69u2usm']) as request_id) r ON e."e_request_id" = r.request_id
         JOIN (SELECT unnest(array ['cldzqdwou0000pu3604veic10', 'cl98n9e7100003x36zaeh7hma']) as participant_id) p
              ON e."e_participant_id" = p.participant_id;
0

There are 0 best solutions below