Jump to content

query for sum of columns in two separate tables


webguy262

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.