Re: replace ... select (why showing duplicates?)

At 10:02 -0800 12/30/02, Qunfeng Dong wrote: Hi, When I do "replace table2 select (cols) table1 where clause" to update some records in the table2, sometimes I got the something like following indicating Duplicates records being detected. --- Query

replace ... select (why showing duplicates?)

Hi, When I do "replace table2 select (cols) table1 where clause" to update some records in the table2, sometimes I got the something like following indicating Duplicates records being detected. --- Query OK, 122259 rows affected (1 min 18.28 sec)