db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kamesh Parameswaran <kapar...@cisco.com>
Subject RE: SQL Syntax issue
Date Fri, 07 Aug 2009 12:40:29 GMT
I guess you need a stored procedure to update multiple tables. The
statements can be wrapped within a transaction. If possible send me your use
case. I'll see how it can be done


From: Priyanka Karnawat [mailto:priyanka@sungraceinfotech.co.in] 
Sent: Friday, August 07, 2009 5:08 PM
To: derby-user@db.apache.org
Subject: SQL Syntax issue

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

View raw message