日期:2014-05-16 浏览次数:20634 次
select a.*,isnull(b.amount,0) as paid, a.amount-isnull(b.amount,0) as balance from a left join b on a.InvoiceNo=b.InvoiceNo