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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.