Neoview SQL Reference Manual (R2.4 SP2)

Examples of Self-Referencing Inserts
• This is an example of a self-referencing insert:
insert into table1 select pk+?, b, c from table1
• This is an example of a self-referencing insert where the target of the insert, table1, is also
used in a subquery of the insert-source:
insert into table1
select a+16, b, c from table2 where table2.b not in
(select b from table1 where a > 16)
The source table is not affected by the insert.
INSERT Statement 147