Re: union, minus and order by

And the ORDER BY clause does not work?

ORDER BY 1, 2, 3 You could always do this too

SELECT ID, CNAME, TNAME
FROM
( ... the guts of your query ... )
ORDER BY 1,2,3 G.Plivna_at_itsystems.lv on 04/30/2000 01:04:03 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Lisa Koivu/GELCO)

Subject: union, minus and order by

Hi!

I have SELECT like this

SELECT
      c1.Id ID, c1.Name CNAME, t.name TNAME FROM blabla
UNION ALL
SELECT
      c1.Id ID, c1.Name CNAME, t.name TNAME FROM blabla2
MINUS
SELECT
      c1.Id ID, c1.Name CNAME, t.name TNAME FROM blabla3
;

The problem is how to get rows ordered by these three fields

Gints Plivna

--
Author:
  INET: G.Plivna_at_itsystems.lv

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).