JOOQ:从另一个表中不存在的表中选择键

import org.jooq.DSLContext;
import org.jooq.Record;
import org.jooq.Result;
import org.jooq.impl.DSL;

import static com.example.jooq.generated.Tables.USERS;
import static com.example.jooq.generated.Tables ORDERS;

public class Example {
    public static void main(String[] args) {
        DSLContext dsl = DSL.using("jdbc:mysql://localhost:3306/mydatabase", "username", "password");

        Result<Record> result = dsl.select(ORDERS.USER_ID)
                                   .from(ORDERS)
                                   .whereNotExists(dsl.selectOne().from(USERS).where(USERS.ID.eq(ORDERS.USER_ID)))
                                   .fetch();

        for (Record record : result) {
            System.out.println(record.getValue(ORDERS.USER_ID));
        }
    }
}