db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From TXVanguard <brett.den...@lmco.com>
Subject Re: Porting to standard SQL
Date Tue, 07 Feb 2012 16:09:34 GMT

Rick,

I've discovered a few more wrinkles in some of the UPDATE/INNER JOIN states
I have to port. Here's an example:

UPDATE T1 INNER JOIN (T2a INNER JOIN T2b ON T2a.B = T2b.B) ON T1.B = T2b.B
SET T2a.D = true WHERE (T2b.E=true AND NOT (T1.F=2 AND (T2b.G=2 OR
T2b.G=1)));

Note that the "table" on the right of the first INNER JOIN is not a table,
rather the result of another INNER JOIN.  Is there any way to rewrite this
in standard SQL?
-- 
View this message in context: http://old.nabble.com/Porting-to-standard-SQL-tp33253800p33279676.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message