2 Replies Latest reply: Jul 18, 2012 1:49 AM by Olivia Briceag RSS

    comparing two tables with same structure

      Hello,

       

      I have 2 tables with invoices and receipts documents from 2 months - May and June, having same fields structure (doc no, doc date, customer name, customer ID, value etc.), and I want to compare them as below

      1. "Closed docs" - only documents from May file which aren't in June file;

      2. "New docs" - only documents from June file which aren't in May file;

      3. "Open docs" - only documents which exists in May and June files.

       

      Haw can I transpose those conditions into script?

       

      Thank you!

       

      Olivia