I Tried to write a VIEW In Sql Server with UNION Operation
Like this:
"SELECT TblRec.Rc_CodeCliBranch,TblRec.Rc_CodeClient, TblRec.Rc_CodeBranch,TblRec.Rc_CodeRecipt, TblBillRec.BR_Amount AS TotalPay, TblRec.Rc_TotalAmount AS TotalRec
FROM TblBillRec INNER JOIN TblRec ON...