Looking to steal any ideas for this problem:

1. Have two tables with same structure in same DBC.
2. One table has had a lot of SQL-Inserts, the other one not.
3. Need to insert all of the values from the larger table to the smaller one, all within one SQL statement. Something like
insert into smalltable (*) values (select * from bigtable where candkey not in (select candkey from smalltable)

?