Re: How to delete duplicates with full row comapring

2008-02-07 Thread Phil
Hello! I am looking for an easy solution for eliminate duplicates but on a row level. I am having 2 tables. 1 destination for all not duplicated info (a) and 1 for input table (b) which might have duplicates related to table a. Now I am using this kind of insert: INSERT INTO a

Re: How to delete duplicates with full row comapring

2008-02-05 Thread Artifex Maximus
On Feb 4, 2008 7:17 PM, Baron Schwartz [EMAIL PROTECTED] wrote: On Feb 4, 2008 11:36 AM, Artifex Maximus [EMAIL PROTECTED] wrote: Hello! I am looking for an easy solution for eliminate duplicates but on a row level. I am having 2 tables. 1 destination for all not duplicated info (a)

Re: How to delete duplicates with full row comapring

2008-02-04 Thread Baron Schwartz
Hi, On Feb 4, 2008 11:36 AM, Artifex Maximus [EMAIL PROTECTED] wrote: Hello! I am looking for an easy solution for eliminate duplicates but on a row level. I am having 2 tables. 1 destination for all not duplicated info (a) and 1 for input table (b) which might have duplicates related to

How to delete duplicates with full row comapring

2008-02-04 Thread Artifex Maximus
Hello! I am looking for an easy solution for eliminate duplicates but on a row level. I am having 2 tables. 1 destination for all not duplicated info (a) and 1 for input table (b) which might have duplicates related to table a. Now I am using this kind of insert: INSERT INTO a SELECT fields