db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kai Ponte <...@perfectreign.com>
Subject Re: Problem with "order by"
Date Sat, 19 Apr 2008 04:03:35 GMT
On Friday 18 April 2008 02:18:25 pm Rick Hillegas wrote:
> Hi Brad,
> As Thomas points out, Derby hews closely to the SQL standard, which does
> not allow an ORDER BY clause in subqueries. The gnarly details of the
> standard grammar can be found here:
> http://savage.net.au/SQL/sql-2003-2.bnf.html

that makes sense

to do a sub-query anyway would be better served by using something like a temp 
table or simply a join

www.filesite.org || www.4thedadz.com || www.perfectreign.com
remember - a turn signal is a statement, not a request

View raw message