[SQL] Skip dups on INSERT instead of generating an error ...

2003-12-12 Thread Marc G. Fournier
I need to be able to run an INSERT INTO / SELECT FROM UNION which combines two tables into one ... *but* ... the INTO table has a primary key on the first column, so if the result of the UNION generates dups, by default, of course, it will generate errors ... what I'd like is to have it so that it

Re: [SQL] Skip dups on INSERT instead of generating an error ...

2003-12-12 Thread scott.marlowe
On Fri, 12 Dec 2003, Marc G. Fournier wrote: > > I need to be able to run an INSERT INTO / SELECT FROM UNION which combines > two tables into one ... *but* ... the INTO table has a primary key on the > first column, so if the result of the UNION generates dups, by default, of > course, it will ge

Re: [SQL] Skip dups on INSERT instead of generating an error ...

2003-12-12 Thread scott.marlowe
On Fri, 12 Dec 2003, Marc G. Fournier wrote: > > I need to be able to run an INSERT INTO / SELECT FROM UNION which combines > two tables into one ... *but* ... the INTO table has a primary key on the > first column, so if the result of the UNION generates dups, by default, of > course, it will ge

Re: [SQL] Skip dups on INSERT instead of generating an error ...

2003-12-12 Thread Tomasz Myrta
Dnia 2003-12-12 21:53, Użytkownik Marc G. Fournier napisał: I need to be able to run an INSERT INTO / SELECT FROM UNION which combines two tables into one ... *but* ... the INTO table has a primary key on the first column, so if the result of the UNION generates dups, by default, of course, it wil