A family of Microsoft relational database management systems designed for ease of use.
As you can understand, I am collecting the value from one table and using to append in another table
Yes,I see.
But as I mentioned before.I 'd better step by step as run sql below one by one.
you can paste them in QBE or db.execute one by one.
drop table table2;
create table table2 (RecoNo integer,Model text,SerialNo text);
insert into table2 (RecoNo,Model,SerialNo) values (1,'m2','3');
//this should be in QBE
select * from table2;
When you obtain the right result,try to replace constants with varieties in sql string.