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.