Calculate remaining amount in SQL Server

Question

hi alli have a table named companies comidcomnamecomdebtand i have a table named payments comidcompaymentsi want code to show comnamecomdebtsum of compayments remainingdebt

moayyad · Accepted Answer

i solve it by this codeselect codeclientnameamountpaamountpa as re from SELECT   clientscodeclientnameclientsamountSELECT  SUMamount AS Expr2 FROM payments WHERE  clientscodepaymentscode  AS Pa  FROM  clients as dd many thanks

Calculate remaining amount in SQL Server

Company

Explore

Follow us

Contact Us