use tables from union query

G

geebee

hi,

i have a UNION ALL query which combines 2 queries.
would like to know how to add to this union all to take one table column
(the table used in the
2nd part of the union all query) and divide it by the column in the second
table (the table used in the
2nd part of the union all query)
to yield new values.

HOW?

Thanks in advance,
geebee
 
K

KARL DEWEY

What you are talking about requires joining tables, not a UNION query.

A UNION query pulls records from the first table/query then the next. You
need to perform the math using related records from JOINed tables.
 
Top