db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dag.wan...@oracle.com (Dag H. Wanvik)
Subject Re: Porting to standard SQL
Date Tue, 07 Feb 2012 16:28:47 GMT
TXVanguard <brett.denner@lmco.com> writes:

> I have several lines that look like this:
>
> UPDATE T1 INNER JOIN T2 ON (T1.A= T2.A) SET T2.B = T1.B  WHERE (T1.C = TRUE
> AND T2.C = 5)

I don't believe Derbys support updating JOINs, which is why you need to
rewrite the query as suggested earlier in this thread.

See Derby's allowed syntax for UPDATE her:
http://db.apache.org/derby/docs/10.8/ref/rrefsqlj26498.html

Thanks,
Dag

Mime
View raw message