4 Replies Latest reply: Feb 13, 2012 6:52 PM by Stefan Wühl RSS

    Create table without repeated values in a column

      Please if anyone can help me with this (I suspect its simple):

       

      I have something like the next table:

       

      Table 1

       

      N

      idclientfilenightssub_idclient
      111011006
      122011006101
      133012004
      144013002
      155014003
      166013002

      401

       

      and need to have a new table like this one:

       

      Table2

      N
      idclientfilenightssub_idclient
      122011006201
      133012004
      155014003
      166013002401

       

      where duplicated values from file are eliminated and only remain the ones that have any value on sub_idclient (and the unique values in file).

       

      Thank you.