4 Replies Latest reply on Oct 14, 2013 11:47 AM by JohnTriggol

    merging information from two tables into a third table

    JohnTriggol

      Title

      merging information from two tables into a third table

      Post

           I have a company solution with a table of invoices and a second table downloaded from customers tracking their payments.  When invoices are matched with the correct payment I would like to combine the two records into a single purged record to a separate archive database.  Not sure the best way to do this?