db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ravinder Reddy <ravinder.pand...@gmail.com>
Subject Re: SQL Syntax issue
Date Fri, 07 Aug 2009 12:06:01 GMT
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

Mime
View raw message