Re: Question insert data

On Sat, 19 Mar 2005 perico(at)12move(dot)nl wrote:

> Hi There,
>
> I've a problem with inserting data and I can't figure out what the problem
> is:
>
>
> what did I do:
>
>
> 1. I've a master table containing about 40000 records. A count(*) provides
> me the exact number.
>
> 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.

Define "based on". Do you mean CREATE TABLE AS or perhaps that the new
table inherits from the old one? If the latter, you will see the rows in
the parent as well as the child if you do a select from the parent.