public void GetMemberTransactionsAsync(string socSecNo, Action<IEnumerable<MemberTransaction>> onSuccess,                               Action<Exception> onFail)        {            var query = Manager.MemberTransactions                      .Where(m => m.socsecno == socSecNo)                      .OrderBy(m => m.TranDate)                   .ExecuteAsync(                       op =>                       {                           if (op.CompletedSuccessfully)                           {                               if (onSuccess != null)                                   onSuccess(op.Results);                           }                           else                           {                               if (onFail != null)                               {                                   op.MarkErrorAsHandled();                                   onFail(op.Error);                               }                           }                       }                );        }

Here is my union and view

SELECT     socsecno, datedeb AS trandate, round(duesamount, 2) AS tranamount, 'D' AS trancode, isnull(duescatdesc, '***') AS trantype, 0 AS receipt, '' AS paidthru, isnull(note, ' ') 
                      AS remark, duesowed.duescatcd
FROM         duesowed LEFT JOIN
                      duescateg ON duesowed.duescatcd = duescateg.duescatcd
UNION ALL
SELECT     socsecno, batchdate AS trandate, round((duesamount * - 1), 2) AS tranamount, 'P' AS trancode, isnull(paytypedesc, '***') AS trantype, receiptno AS receipt, paidthru, 
                      isnull(checkno, ' ') AS remark, duescatcd
FROM         memdues LEFT JOIN
                      paytypes ON memdues.paytype = paytypes.paytype

Am I going to have to read both tables and merge them myself in code or can this be fixed?