Updating Existing Data

See Also

The structure of a typical SQL statement that updates data with imported information is:

UPDATE table_x

SET column_y =

(

   SELECT column_y

   FROM external_set1 ext1

   WHERE ext1.ext_set_id = tx.table_id

)

WHERE EXISTS

(

SELECT ' '

   FROM external_set2 ext2

   WHERE …

)