"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]>