如何使用ColdFusion 2018/Lucee5.x创建网格输出以显示来自两个查询的数据

<cfquery name="query1" datasource="your_datasource">
    SELECT * FROM table1
</cfquery>

<cfquery name="query2" datasource="your_datasource">
    SELECT * FROM table2
</cfquery>

<cfset combinedData = []>

<cfloop query="query1">
    <cfset rowData = {}>
    <cfset rowData.column1 = query1.column1>
    <cfset rowData.column2 = query1.column2>
    <!-- 将其他需要显示的数据字段添加到rowData结构体中 -->
    <cfset ArrayAppend(combinedData, rowData)>
</cfloop>

<cfloop query="query2">
    <cfset rowData = {}>
    <cfset rowData.column1 = query2.column1>
    <cfset rowData.column2 = query2.column2>
    <!-- 将其他需要显示的数据字段添加到rowData结构体中 -->
    <cfset ArrayAppend(combinedData, rowData)>
</cfloop>

<table>
    <tr>
        <th>Column 1</th>
        <th>Column 2</th>
        <!-- 添加其他表头 -->
    </tr>
    <cfloop array="#combinedData#" index="row">
        <tr>
            <td>#row.column1#</td>
            <td>#row.column2#</td>
            <!-- 添加其他数据字段 -->
        </tr>
    </cfloop>
</table>