Re: SQL Syntax issue

[Rick Hillegas]

Priyanka Karnawat wrote:

Can we use 2 or more tables in UPDATE clause?
eg. UPDATE T1, T2
SET T1.name = 'abc'
WHERE T1.id = T2.id

Hi Priyanka,

I'm not sure what you are trying to do, but the following query may help:

update t1
set name ='abc'
where id in ( select id from t2 );

Hope this is useful,
-Rick