3 Replies Latest reply: Jun 15, 2018 5:03 AM by Imran Syed RSS

    creating a column out of present column

    Imran Syed

      Hi Experts,

       

      TableA:

      TerritoryNo,TerritoryName

      1,AS

      2,SD

      3,ER

      4,FG

      5,ER

       

      I want to create a seperate column with the consolidation of Territory No's  3,4,5

       

      TableB:

      1,AS

      2,SD

      '(3,4,5 Territories)',

       

      How can we achieve this?

       

      Appreciate your Help