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



      ‘Salesman1’ as Salesman


      Salesman 2



      ‘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?