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: Issue with COUNT function
Date Fri, 21 Jan 2011 20:08:49 GMT
Chris Wilson <chris@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:


When you have a table subquery, the correlation name is mandatory. The
"AS" is optional.


View raw message