Union two query results in horizontal way??

[kelvin2088]

I have two queries yielding following results:

Cerritos Service Center	$70,500.00
New York Academy	$82,000.00

<caption> qrySelectedRegionCC_CAPEX </caption><thead>
[TH="bgcolor: #c0c0c0"] CC Name [/TH]
[TH="bgcolor: #c0c0c0"] CAPEX [/TH]

</thead><tbody>
</tbody><tfoot></tfoot>

Cerritos Service Center	$42,000.00

<caption> qrySelectedRegionCC_Personeel </caption><thead>
[TH="bgcolor: #c0c0c0"] CC Name [/TH]
[TH="bgcolor: #c0c0c0"] Personeel [/TH]

</thead><tbody>
</tbody><tfoot></tfoot>

Is there any query that can help me combine two results into single set like this:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]CC Name[/TD]
[TD]CAPEX[/TD]
[TD]Personeel[/TD]
[/TR]
[TR]
[TD]Cerritos Service Center[/TD]
[TD]70500[/TD]
[TD]42000[/TD]
[/TR]
[TR]
[TD]New York Academy[/TD]
[TD]82000[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]


Thanks!!

 

[Joe4]

You're welcome.