how can i merag beetween 2 tables in sql ?
Posted on 2006-11-05
hi there , i have a Financial software in the Db i have 2 tables
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
500(receipt) so his balance is -500
i am on c# dot net 1.0 WinForms App.