Hi,

I think , you can't do that.
Instead use nested queries (I am not sure Derby supports nested queries though).


On Fri, Aug 7, 2009 at 5:07 PM, Priyanka Karnawat <priyanka@sungraceinfotech.co.in> wrote:
Can we use 2 or more tables in UPDATE clause?
eg. UPDATE T1, T2
SET T1.name = 'abc'
WHERE T1.id = T2.id



--
Ravinder Reddy