Inserting New Data

Previous Next

See Also

The structure of a typical SQL statement that imports new data is:

INSERT INTO table_x

SELECT column....

   FROM external_set

   WHERE NOT EXISTS

   (

   SELECT ' '

   FROM table_x

   WHERE table_x.column_id = external_set.column_id)