Thanks for the help Igor. :-)
Dave
On 3/7/2015 1:37 PM, Igor Tandetnik wrote:
>
>
> 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);
>
>
