onyxtacular
IS-IT--Management
Hi Everyone,
I trying to add data to the table based on query of the same table. Basically we have a several thousand entries with 21 in the option filed and want to make duplicates of the entries with 50 in the option field and change the string in the description field to something else.
Although it seems like it would be a simple query I'm stuck how to write it out.
Update table cfgmaster
set option=50
where (Select *
where option=21);
I tried this but was rejected.
Thanks for viewing.
I trying to add data to the table based on query of the same table. Basically we have a several thousand entries with 21 in the option filed and want to make duplicates of the entries with 50 in the option field and change the string in the description field to something else.
Although it seems like it would be a simple query I'm stuck how to write it out.
Update table cfgmaster
set option=50
where (Select *
where option=21);
I tried this but was rejected.
Thanks for viewing.