التعامل مع الحقول الحسابيه - نسخة قابلة للطباعة

كود :
SELECT        person.per_id, person.per_name, person.per_type, person.address, person.phone, person.phone2, person.email, person.active, person.begin_balance, 
                         person.balance_currency, person.note,
                             ((SELECT        ISNULL(SUM((Bill_detail.total_in - Bill_detail.total_out) * currency_.price_conversion), 0) AS Expr1
                                 FROM            Bill LEFT OUTER JOIN
                                                           Bill_detail ON Bill.doc_id = Bill_detail.Bill_id LEFT OUTER JOIN
                                                           currency_ ON Bill.paid_curr = currency_.id
                                 WHERE        (Bill.bill_person_id = person.per_id)) +
                             (SELECT        ISNULL(SUM((voucher.vou_debtor - voucher.vou_loaner) * c.price_conversion), 0) AS Expr1
                                FROM            voucher LEFT OUTER JOIN
                                                         currency_ AS c ON voucher.vou_curr = c.id
                                WHERE        (voucher.vou_pers_id = person.per_id))) + isnull(person.begin_balance * currency__1.price_conversion,0) AS balance
FROM            person LEFT OUTER JOIN
                         currency_ AS currency__1 ON person.balance_currency = currency__1.id
WHERE        (per_type =@type )