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
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