Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Question Unanswered: Update 1 colum with the data of 2 colums in the same table.


    I'am new to databases, i hope someone can help me.

    I need to merge 2 colums from the same table, into a other colum in the same table. is this possible ? and how can i do it.

    a + b = ab

    I think it's a update or insert statement

    Thank for your help.

  2. #2
    Join Date
    Nov 2003
    UPDATE yourtable
    SET col_ab = col_a + col_b;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts