On 12/1/05, Mark Fenbers <Mark(dot)Fenbers(at)noaa(dot)gov> 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 UPDATE OF tablename" clause is for?)
>
> Mark
>
INSERT INTO table SELECT ....
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)