如何在jooq中创建多列子查询

import static org.jooq.impl.DSL.*;

public class JooqExample {
    public static void main(String[] args) {
        // 创建一个多列子查询
        SelectConditionStep<Record2<Integer, String>> subquery = select(TABLE1.ID, TABLE2.NAME)
                .from(TABLE1)
                .join(TABLE2)
                .on(TABLE1.ID.eq(TABLE2.ID))
                .where(TABLE1.STATUS.eq("ACTIVE"));

        // 在主查询中使用多列子查询
        Result<Record2<Integer, String>> result = create.select(subquery.field1(), subquery.field2())
                .from(subquery)
                .fetch();

        // 打印查询结果
        for (Record2<Integer, String> record : result) {
            Integer id = record.get(subquery.field1());
            String name = record.get(subquery.field2());
            System.out.println("ID: " + id + ", Name: " + name);
        }
    }
}