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 < [email protected]> 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
