I have two tables:
Table accounts with the value column with two records totaling 1100; Table accounts_receiver with the value column with a record totaling 500
I want to perform a query where I get the sum of each table, I tried something like:
SELECT SUM (accounts.value) totals, SUM (accounts_receives.value) the total entries FROM accounts, accounts_receber
However, the total entries I receive from the query are 1000 instead of 500. Why does this occur?