在JOOQ联合中选择常量

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

// 创建常量字段
Field<Integer> constantField = field(42, Integer.class);

// 执行查询
Result<Record2<Integer, String>> result = create.select(constantField, table1.field("column1"))
                                              .from(table1)
                                              .join(table2)
                                              .on(table1.field("id").eq(table2.field("id")))
                                              .fetch();

// 遍历查询结果
for (Record2<Integer, String> record : result) {
    Integer constantValue = record.get(constantField);
    String column1Value = record.get(table1.field("column1"));
    
    // 处理查询结果
    // ...
}