I wrote the following queris and get result like that way
Income Query
select 'Dispatch Local' as 'Head',Sum(TotalPrice) 'Amount' from tblDispatchLocal
union all
select 'Sales Trans:' as 'Head',Sum(P_Price) 'Amount' from tblSalesTran
union all
select 'Loan Recovery:' as 'Head',Sum(R_Amount) 'Amount' from tblLoanRefund;
output is
Dispatch Local 40500
Sales Trans: 51600
Loan Recovery: 2000
94100
Expenses Query
select 'Feeding Consumption' as 'Head' , Sum(Price) as Amount from tblConsumption
union all
select 'Misc Consumption' as 'Head' , Sum(Rate) as Amount from tblConsumptionMedicine
output is
Feeding Consumption: 1000
Misc Consumption: 3100
4100
Now finally Required Output by writing sql query
Income – Expenses = Profit & Loss
94100 – 4100 = 90000
how to get solution Profit & Loss : 90000