webguy262 Posted March 14, 2009 Share Posted March 14, 2009 I'm trying to get the sum of column A in table X and of column B in table Y. I need these as two separate sums, not looking to add them together. Here's what I have, but it is giving wrong results: Select sum(novo_billing.balance) as sum_balance, sum(novo_payments.payment) as sum_payment from novo_billing, novo_payments Link to comment https://forums.phpfreaks.com/topic/149424-query-for-sum-of-columns-in-two-separate-tables/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.