4 Replies Latest reply: Nov 29, 2017 7:00 AM by kumar rishikesh RSS

    Getting Unique Records after joining 2 or more tables

    kumar rishikesh

      Hi All,

       

      I have 3 tables as drawn below:

      Table 1:

      StudentSubjects

      Books

      A22
      B2
      C32
      D2

       

      Table 2:

      StudentSubjects

      Books

      A2
      B32
      C32
      D2

       

      Table 3:

      StudentSubjectsBooks
      A22
      B32
      C

       

      2
      D2

       

      Now my requirement is to get a 4th Table as drawn below after merging the above 3 tables.

      Table 4:

      StudentSubjectsBooks
      A22
      B32
      C32
      D2

       

      TIA

       

      Regards,

      Rishikesh