add the subtract the sum() of 2 table

homer.favenir · #1 (**permalink**) 11-20-08, 22:11

hi,
sorry my title is wrong. subtract 2 tables.

i know this is simple for you guys, but i cant find a way
can anyone please help me...

i want to subtract the sum() of my field from 2 tables.

Code:

SELECT amount as 'sum' FROM mafee_db.mafee_capital_tbl where acc_type = 'cash on hand'
-
SELECT sum(principal) as 'sum' FROM mafee_db.pawnshop_tbl where servicetype = 'pawn'

thanks in advance

r937 · #2 (**permalink**) 11-20-08, 22:21

Code:

SELECT ( SELECT amount 
           FROM mafee_db.mafee_capital_tbl 
          WHERE acc_type = 'cash on hand' )
     - ( SELECT sum(principal)
           FROM mafee_db.pawnshop_tbl
          WHERE servicetype = 'pawn' ) AS answer

homer.favenir · #3 (**permalink**) 11-20-08, 22:27

thanks, youre a great help

Internet Services

Web Development

Digital Marketing

Consumer Tech