[sqlite] Can I copy one column of data to another table?

[Igor Tandetnik]

On 3/7/2015 11:42 AM, Dave wrote:
> Now when trying to use the database I see that I should have made 1
> table with all the related data (I think) and am trying to copy one
> column of data at a time to the "main" table. Can that be done and if so
> how? The data in all the columns has to line up with the ID numbers.

insert into WideTable(ID, C1, C2, C3)
select t1.ID, t1.C1, t2.C2, t3.C3
from NarrowTable1 t1 join NarrowTable2 t2 using (ID) join NarrowTable3 
t3 using (ID);