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 UPDATE OF tablename" clause is for?) > > Mark >
INSERT INTO table SELECT .... -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
