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)




      RESIDENT Table2;


      Thank you for your help.