<div>
<div class="content wysiwyg-content">
hi there , i have a Financial software in the Db i have 2 tables 
 
invoice table 
receipt &nbsp;table 
 
i have a cust that have 2 invoice and 1 receipt 
i want to get the balance 
 
i need to get all the invoice &nbsp;sum and get all the receipt sum as well to calculate the his balance 
 
but i need to see the actions like in the bank 
invoice &nbsp; &nbsp;balance 
-500 &nbsp; &nbsp; &nbsp; &nbsp;-500 
-500 &nbsp; &nbsp; &nbsp; -1000 
500(receipt) so his balance is &nbsp;-500 
i am on c# dot net 1.0 WinForms App. 
thanks .... 
 
 
&nbsp; &nbsp; &nbsp; &nbsp; 
 

</div>
</div>

hi there , i have a Financial software in the Db i have 2 tables 

invoice table
receipt  table

i have a cust that have 2 invoice and 1 receipt 
i want to get the balance

i need to get all the invoice  sum and get all the receipt sum as well to calculate the his balance

but i need to see the actions like in the bank 
invoice    balance
-500        -500
-500       -1000
500(receipt) so his balance is  -500
i am on c# dot net 1.0 WinForms App.
thanks ....


       



how can i merag beetween 2 tables in sql ?

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).