3 Replies Latest reply: Jul 11, 2013 9:58 AM by Mohit Sharma RSS

    Join a table without increasing lines, but columns instead

      Hello,

       

      I have these 2 tables and would like to obtain the result table.

      Table1:
      IDName
      1A
      2B
      3C

       

      Table2:
      IDCompanyField1
      11000X
      12000Y
      21000X
      22000Z
      32000Y

       

       

      Result:
      IDNameComp.1000Comp.2000
      1AXY
      2BXZ
      3CY

       

      I hope anyone can help. Thanks