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

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