Re: [sqlite] insert into table problem

yanhong ye wrote: >> insert into table3(name,mark,mdate) select name,mark,now() from table2 >> where table2.name=table1.name; > > Not work, I don't know what's problem. Did you actually read the error messages? sqlite> create table table1(name); sqlite> create table table2(name,mark); sqlite>

[sqlite] insert into table problem

> >insert into table3(name,mark,mdate) select name,mark,now() from table2 >where table2.name=table1.name; Not work, I don't know what's problem. ___ sqlite-users mailing list sqlite-users@sqlite.org