assigning stored data to a different identifier

[John Harris]

So here's my problem. There are a lot of item descriptions that I need to assign to another user for their usage. I know it sounds crazy, but that's the business rules.

For example, I have:

User_ID Item_Code Item_Desc
alpha 222 belt sander

I need to copy all Item_Code and Item_Desc to users beta, delta, gamma, theta...etc etc

I was thinking something along the lines of something resembling

Insert item_code.item, item_desc.item into table(user)
where user='beta';

and then running subsequent series from there.
I need to copy all the item_code, item_desc that are associated with one user_id and copy them to other IDs

Thanks!