'how to get ALL amount_left with ALL partyname checking that ALL partyname same as in another table with in MYSQL
Here is the First Table:
Sales:
Restaurant Teliabagh 80000
Restaurant Teliabagh 20000
SHRI BALAJI 50000
Bhola ji 50000
Ajay 50000
Second Tables:
Cash:
Restaurant Teliabagh 20000
Restaurant Teliabagh 20000
Ajay 25000
I was able to get money_left for one party AJAY only amount not with his name
here is the command:
SELECT (select sum(totalamount) from acc.sales where Partyname='Ajay')-(select sum(Amountrecevied) from acc.cash where Party_name='Ajay') as money_left;
and output as
money_left
25000
BUT my problem is that Here I want to display the ALL Partyname with Money_left After subtraction (totalamount) of the partynames in sales table form (amount received) in cash tables.
IT will be fine if it displays partyname and amount as NUll after subtraction them.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
