operation must be updateable query error?

dhx10000

Registered User.
Local time
Today, 02:13
Joined
Mar 3, 2006
Messages
12
Can someone tell me why this query is causing this error? I don't understand it:

UPDATE 1_2_06 SET ROLE = (SELECT ROLE FROM UserRoleData WHERE USERNAME=ASSIGNED_TO)
WHERE EXISTS (SELECT ROLE FROM UserRoleData WHERE USERNAME=ASSIGNED_TO);

thank you
 

Users who are viewing this thread

Back
Top Bottom