0 Replies Latest reply: Jun 13, 2014 6:29 PM by kazyskiyn0w RSS

    Merge or update command to update entire table with join in another table

    kazyskiyn0w

      Hi ,

       

      I have a fact table FAC  with 35 columns/fields and I need to update entire table with join to anotjer table FAC_backup (which is the backup of this table created during the ETL process).

      Is it possible to update entire table FAC without having to inform all 35 columns in the command - in the SET part ? Because there are 35 columns.

       

      If it's possible, Can someone show me in a simple example how can I do it?

       

      Thanks.

      KZ