如何使用JooQ联合两个具有相同列和数据类型的不同表？

Configuration configuration = new DefaultConfiguration()
    .set(SQLDialect.MYSQL)  // 设置数据库类型
    .set(connectionProvider);  // 设置数据库连接提供者

DSLContext dslContext = DSL.using(configuration);

Table<Record> table1 = DSL.table("table1");
Table<Record> table2 = DSL.table("table2");

Field<Integer> column1 = DSL.field("column1", Integer.class);
Field<String> column2 = DSL.field("column2", String.class);

SelectJoinStep<Record2<Integer, String>> query = dslContext
    .select(column1, column2)
    .from(table1)
    .unionAll(
        dslContext.select(column1, column2)
            .from(table2)
    );

Result<Record2<Integer, String>> result = query.fetch();

for (Record2<Integer, String> record : result) {
    Integer value1 = record.get(column1);
    String value2 = record.get(column2);
    
    // 处理查询结果
}