Need help with adding result from 2 queries

SCRUBBIE1

Hi. I need to be able to add the results from two queries, which retrieve data from two different tables. The tables can't be joined because there are no common fields. (Edit: well, there is one, managers)

The first query returns ( among other things) salesdemo.bmgr, SUM(salesdemo.vsc) as vscincome, and SUM(countdemo.vsc) as vscnum.

The second query returns SUM(profit) as vscincome. I need to combine the two vscincomes to get the vscincome total.

The only problem is that I HAVE NO CLUE how to do this...

Any help appreciated.
Cori

mrhappiness

I guess both statements return more than one single line?

How do you now wich vcsincome to add to which vcsincome if there are no cmommon fields?

SCRUBBIE1

Originally posted by mrhappiness
I guess both statements return more than one single line?

Yes, both statements return several values, grouped by manager.

How do you now wich vcsincome to add to which vcsincome if there are no cmommon fields?

the managers are in both tables, so I guess there is one common field, but its the only one. I did try to do a join on the managers, and got null values cuz no other part of the rows match up.

I need to add the total vsc income from each table together for each manager. I've never had so much trouble adding two numbers together in my life....

Cori