"shum [Ming Yik]" <[EMAIL PROTECTED]> wrote:
>
> create table test01( FLD01 char(3) default '');
> create table test02( FLD01 char(3) default '');
>
> insert into test01(FLD01) values('001');
> insert into test01(FLD01) values('002');
>
> insert into test02 select * from test01 ;
>
>
>
> then you will find that in test01:
> 001
> 002
>
> then you will find that in test02:
> 001
> 002
> 001
> 002
>
That's not what I get:
create table test01( FLD01 char(3) default '');
create table test02( FLD01 char(3) default '');
insert into test01(FLD01) values('001');
insert into test01(FLD01) values('002');
insert into test02 select * from test01 ;
select 111, * from test01;
111|001
111|002
select 222, * from test02;
222|001
222|002
I'm not sure what it is you are doing wrong. Are you
typing this in at the command-line shell? Or are you
using some kind of language binding?
--
D. Richard Hipp <[EMAIL PROTECTED]>
