al4629740
asked on
copying one row to another
I have a table named tblOrgRegistrations
I have a column named CDTESType and I want to transfer the data in this column to a column named SubGroup in the same table where the Agency column = CDTES
Is this correct below
UPDATE tblOrgRegistrations
SET SubGroup = CDTESType where Agency = 'CDTES'
I have a column named CDTESType and I want to transfer the data in this column to a column named SubGroup in the same table where the Agency column = CDTES
Is this correct below
UPDATE tblOrgRegistrations
SET SubGroup = CDTESType where Agency = 'CDTES'
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.