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 -- kai www.filesite.org || www.4thedadz.com || www.perfectreign.com remember - a turn signal is a statement, not a request
