Move column from 1 table to another

[plcguru]

Hi,

newbie question :ermm:

I need to move the entire 'country' column from the user table to the userfield table. The userid column is in each so I guess that's how they can match.

Is this done with a join? What's the query?

Thanks!

[Dean C]

Hm you can't do with one query AFAIK.

[sabret00the]

best bet would be to make the column in the userfield table and then make a script that will do em quickly although intensively and then just drop the original column.