1 Reply Latest reply: Jan 22, 2016 10:58 AM by Olly Bond RSS

    Monarch 10.5 Right Outer Join

    thecontroller _

      HI,

       

      I am using Monarch 10.5.  I have 2 tables [sales invoice numbers(left table- invoice number is a unique key) and cash payments and credit notes made against those invoices (right table-the same invoice number can occur more than once)].  There may be multiple payments made against the same invoice number.  I want to show all the payments against a particular invoice number hence my desire to do a right join on the cash payments/credit note table.  How do you do this in Monarch 10.5?

       

      Thanking you  in advance.