use tables from union query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top