PDA

View Full Version : join and sum command


anthony
09-24-2008, 06:04 AM
I have two tables mysql that I need to do a join and sum

one is

SELECT sum(ntotal) AS total from table a where seller is =6

SELECT sum(ntotal) AS total from table b where seller is =6

I need to do a join to come up with one total, they both have in common the seller field

thanks
tony