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:

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

Mime
View raw message