5 Replies Latest reply: Jun 29, 2014 11:55 AM by Khabat Stravan RSS

    Merge/combine two tables

    Khabat Stravan

      Hello everyone,

      I have two tables (Care and Model) as I want to combine into a table

       

      Table 1 (Car)

      CarID     Car

      1             Volvo

      2             Ford

       

      Table 2 (Model)

      CarID     Model

      1             V70

      1             S40

      1             XC60

      2             C-max

      2             Focus

       

      The combined table should be so:

      CarID       Car       Model

      1              Volvo     V70, S40, XC60

      2              Ford      C-max, Focus

       

      How should I write the script for this?

      Thanks in advance.