[SQL] APPEND INTO?

I want to SELECT INTO mytable WHERE (criteria are met), except that I want to APPEND into an existing table the rows that are selected, instead of creating a new table (which SELECT INTO will do). How can this be done? (Is this what the FOR UPDATE OF tablename clause is for?) Mark

Re: [SQL] APPEND INTO?

On 12/1/05, Mark Fenbers [EMAIL PROTECTED] wrote: I want to SELECT INTO mytable WHERE (criteria are met), except that I want to APPEND into an existing table the rows that are selected, instead of creating a new table (which SELECT INTO will do). How can this be done? (Is this what the FOR

Re: [SQL] APPEND INTO?

Mark Fenbers [EMAIL PROTECTED] writes: I want to SELECT INTO mytable WHERE (criteria are met), except that I want to APPEND into an existing table the rows that are selected, instead of creating a new table (which SELECT INTO will do). How can this be done? INSERT INTO foo SELECT whatever