Table values of other tables....hmm...

[run_GMoney]

Can you set the field values of one table equal to the values of one field in a different table? For instance, if I have a field in one table with the values of:

Column1 |...
-----------+---
Field1
Field2
Field3

Can I set another table up with fields that had those values like this:
Field1 | Field2 | Field3
--------+--------+---------

Thanks

[run_GMoney]

Nevermind, I got it. I just used SELECT to get the items from the first table, stored them in an array, cycled through that array, and used the ALTER TABLE...ADD statements to insert the new fields.