Virtual database table creation

I haven't learn SQL yet, just understand basic things.
but I need to write SQLite code for quick solution. Please help.


I have two table as bellow:

tablea code char(4), desc char(50), unit char(4)
tableb code char(4), amount char(6)

How do write sql statement to generate tablec according to tableb?

tablec code char(4), desc char(50), unit char(4), amount char(6)

Q1: if the two tables are in the same database file, how to create tablec?
Q2: if the two tables are in different database files, how to create tablec?

-sundale

There is a SQLite example at the Wiki, which creates a table on the fly as you like to.