2 Replies Latest reply: Oct 7, 2014 6:38 AM by anbu cheliyan RSS

    Removing duplicate data from different tables

    Paul Wonford

      Hi guys.

       

      I have two tables

       

      Salesman 1

      PIN

      Sales_amount

      ‘Salesman1’ as Salesman

       

      Salesman 2

      PIN

      Sales_amount

      ‘Salesman2’ as Salesman

       

      There is a chance that someone might apply via more than one salesman. For example they go to Salesman2 to make their original application and then realise they have made a mistake and go to Salesman1 to apply again.

       

      I’d like to identify anyone who appears in more than one table and remove them from the Salesman1 table. Can this be done?