On Sat, 2005-03-19 at 18:36 +0100, perico(at)12move(dot)nl wrote:
> 2. I've create a table based on from the master. I copied a fraction from
> the master into the new table using a where clause (insert into ... select
> * from ... where a = b . The number of records copied is about 2553.
>
> Issueing the same select statement on the master table gives me a list of
> 5106 which is twice the number of copied records.
sounds like you inserted into the master table instead of the new table.
can you show us the exact SQL you used?
or even better, can you make this happen in a simple test case?
gnari