combinening two query results into one ?

[mezzanine1974]

There is a table which has [ACTIVITY_DESCRIPTION], [MATERIAL_PRICE],
[LABOR_PRICE] fields. I created two queries- Query1 sorts
[MATERIAL_PRICE] and Query2 sorts [LABOR_PRICE] in ascending order,
according to a specific common criteria for [DESCRIPTION]. So, Query1
and Query2 produces same number of row for every query.

I would like to combine query results into a single table, so i will
have [MATERIAL_PRICE] and [LABOR_PRICE] in ascending order for a
common criteria of [DESCRIPTION]. My target is to make a chart for
values of material and labor prices in ascending order.

Can I do ?

 

[Stefan Hoffmann]

hi,

I would like to combine query results into a single table, so i will
have [MATERIAL_PRICE] and [LABOR_PRICE] in ascending order for a
common criteria of [DESCRIPTION]. My target is to make a chart for
values of material and labor prices in ascending order.

You have the following two options:

a) Use one query and order by [MATERIAL_PRICE] and [LABOR_PRICE].

b) Create a new union query to combine the results of both queries.
E.g. SELECT * FROM Q1 UNION ALL SELECT * FROM Q2

As far as i understand you, you just need solution a).


mfG
--> stefan <--