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

    comparing two tables with same structure



      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!