6 Replies Latest reply: Mar 10, 2016 4:01 PM by Mark Graham RSS

    added and removed IDs from 2 tables

    Mark Graham

      Hi all,

       

      I'm working on a req. where i have 2 tables:

       

      Table1:                        Table2:                                     

      ID, Name                 ID, Name            

      1,A                                1,A

      2,B                                 2,B

      3,C                                 3,C

      4,D                                 6,F

      5,E                                  7,G

       

       

           In the output i want to see

      newly added records as :

      ID, Name

      6,F

      7,G

       

      Removed records as:

      ID, Name

      4,D

      5,E