kelvin2088
Board Regular
- Joined
- Mar 11, 2010
- Messages
- 78
I have two queries yielding following results:
<caption> qrySelectedRegionCC_CAPEX </caption><thead>
</thead><tbody>
</tbody><tfoot></tfoot>
<caption> qrySelectedRegionCC_Personeel </caption><thead>
</thead><tbody>
</tbody><tfoot></tfoot>
Is there any query that can help me combine two results into single set like this:
<tbody>
</tbody>
Thanks!!
CC Name | CAPEX |
---|---|
Cerritos Service Center | $70,500.00 |
New York Academy | $82,000.00 |
<caption> qrySelectedRegionCC_CAPEX </caption><thead>
</thead><tbody>
</tbody><tfoot></tfoot>
CC Name | Personeel |
---|---|
Cerritos Service Center | $42,000.00 |
<caption> qrySelectedRegionCC_Personeel </caption><thead>
</thead><tbody>
</tbody><tfoot></tfoot>
Is there any query that can help me combine two results into single set like this:
CC Name | CAPEX | Personeel |
Cerritos Service Center | 70500 | 42000 |
New York Academy | 82000 | 0 |
<tbody>
</tbody>
Thanks!!