3 Replies Latest reply: Jul 10, 2013 5:58 AM by Mohit Sharma RSS

    Add a column to a table

      Hi !

       

      I have a table : Table1 which contains many informations like ID, date, name ... and another one : Table2 which contains the ID and the weight.

      I would like to add, for each ID of the first table, the weight.

       

      I tried with this script but it creates new rows in table1 and i don't know why. I want to keep the same number of row in table 1.

       

      INNER JOIN (Table1)

      LOAD

                 ID,

                weight

      RESIDENT Table2;

       

      Thank you for your help.