Iam trying to update db using the following query.
Am getting error while executing the same.

UPDATE A
SET LAST_NAME = 'SUJAY'
FROM TABLE1 A, TABLE2 B, TABLE3 C
WHERE A.CH_ID = B.C_ID
AND B.S_S_ID = C.S_ID
AND C.S_ID = '483075'

Can some one help me in finding wots problem with this query.

Thanks in advance

What is the error you are receiving ? Can you paste the error in your reply ?


Thanks and Regards,
Ramanan

Hii sri_smilesb4u !!
You can't use alias name while updating the records in main outer query .

try to change like :)
>>

update TABLE1
set TABLE1.LAST_NAME='Sujay'
 from
(SELECT TABLE2.C_ID
  FROM TABLE2
 INNER JOIN
   TABLE3 ON TABLE2.S_S_ID=TABLE3.S_ID
 WHERE TABLE3.S_ID ='483075'
)as A
where TABLE1.CH_ID=A.C_ID

Hope this will help you; nice id u have


Cheers :)

vinod