simple query?

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

Guest

I have 2 tables, Table 1 has department, account and
amount & Table 2 has department, account and percent.

Table 1 Table 2

Accounting salary 1200 Acct All 50%
Accounting Travel 1000 Manu Sal 25%
Manufactur Salary 5000 Manu Other 10%
Manufactur Travel 1000
Manufactur Cloth 500

My results should be as follows:

Acc 1200*50
Acc 1000*50
Manu 1000*25
Manu 1000*10
Manu 500*10

ie, 'All' should apply to all the accounts and 'Other' to
the rest of the accounts. I am stumped. any help is
greatly appreciated.

Thanks
Rachita
 
I suspect that BOTH department AND Account should be included in the JOIN
definition and you have only used department
Terry
 
Back
Top