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