Re: order by in a union
- From: Jeremy <jeremy0505@xxxxxxxxx>
- Date: Wed, 31 May 2006 18:42:58 +0100
In article <Jokfg.9183$lb.830635@xxxxxxxxxxxxxx>, Marc Miller says...
Hello all,
I am having a heck of a time getting a UNION to ORDER BY. I'm working with
SQL Server Reporting Services,
but even when I try the query in SQL*Plus, I receive the same error which is
'SQL command not properly ended'
and it point to the "O" in word "ORDER" on the last line of the query.
I've tried "ORDER BY project, accounting_date" and I've trime "ORDER BY 3,6"
and I've even tried just
"ORDER BY project", "ORDER BY d.project" and "ORDER BY 2". Same error each
time.
Here are my syntax (which work fine without the "ORDER BY " clause.
Select poh.SEGMENT1 AS PO_NUM, d.VENDOR_NAME,SUBSTR(d.project,1,3) || '-' ||
<snip>
AND po_distribution_id IS NULL order by accounting_date, project
ORDER BY project, accounting_date
/
2 order by clauses?
--
jeremy
.
- Follow-Ups:
- Re: order by in a union
- From: Marc Miller
- Re: order by in a union
- References:
- order by in a union
- From: Marc Miller
- order by in a union
- Prev by Date: order by in a union
- Next by Date: Re: order by in a union
- Previous by thread: order by in a union
- Next by thread: Re: order by in a union
- Index(es):
Relevant Pages
|
|
