Chris Wilson <ch...@aptivate.org> writes: > I think that every sub-SELECT must have a table alias in Derby, so add "AS > t" to the end of the query (after the closing parenthesis) and it might > work :)
This is correct, cf syntax here: http://db.apache.org/derby/docs/10.7/ref/rrefsqlj33215.html#rrefsqlj33215 When you have a table subquery, the correlation name is mandatory. The "AS" is optional. Dag