Re: Explain THIS, please!

In article <1992Dec22.163411.557_at_hhcs.gov.au>, champs_at_hhcs.gov.au writes:
|> In article <1gtd91INN7ln_at_ef2007.efhd.ford.com>, wwm_at_ef5003.efhd.ford.com (Bill Meahan) writes:
|> > I'm tearing my hair out at the following:
|> >

-------stuff deleted------

|> **************************
|> WARNING ! WARNING ! ORDER BYs DON'T WORK IN SUB-QUERIES
|> At least they don't in our version (VAX 3.0.9.7.1). As soon as we put an order
|> by in a sub-query we got your error (group by worked fine though). The SQL
|> reference says you can't have order by in a sub-query on insert,update, and
|> delete but does not say they're illegal in a select.
|>

The Oracle7 documentation is more specific:

"The ORDER BY clause cannot appear in subqueries within other statements".

-------more deleted------

|>
|> Hope this helps.
|> ------------------------------------------------------------------------------
|> /\ Steven Champness
|> / \ Dept Health Housing and Community Services
|> / \ Brisbane Queensland
|> / \ via
|> / / \ Canberra Australia
|> \ / / /
|> \/ / / / MACINTOSH SOFTWARE AXIOM : If you need a manual to operate it
|> \/ / / it wasn't designed properly in the
|> \/ / first place !
|> \/
 

-- 
                               John Peach
                           Chevron (UK) Ltd.
   Ninian House, Crawpeel Road, Altens, Aberdeen, AB1 4LG, Scotland.
   Internet: epeas_at_aberdeen.chevron.com       Phone: +44 224 242637