2 Replies Latest reply: Feb 8, 2012 4:30 AM by Jens Ophalvens RSS

    How to compare data in a table?

    Jens Ophalvens

      Hi,

       

      I have one table that holds data of invoices. I want to test if I have duplicate invoices. A duplicate invoice is an invoice with the same invoice number, customer name, invoice date and invoice amount.

      Do you have any idea how I could build up this test an generate a table with these duplicate invoices?

       

      Thanks in advance!

      Kind regards,

      Jens