View and group by
From: Michal Piasecki <michal.piasecki_at_cr-media.com.pl>
Date: Mon, 13 Dec 1999 17:33:09 GMT
Message-ID: <p5a54.51699$Oo3.1178200_at_news.tpnet.pl>
[Quoted] I have no Idea how to create view and keep all relations in my query I need to keep order in my result by the value of NM field so:
Michal Piasecki
CR Media
tel: (+48)(022)690-68-62
[Quoted] e:mail - michal.piasecki_at_cr-media.com Received on Mon Dec 13 1999 - 18:33:09 CET
Date: Mon, 13 Dec 1999 17:33:09 GMT
Message-ID: <p5a54.51699$Oo3.1178200_at_news.tpnet.pl>
[Quoted] I have no Idea how to create view and keep all relations in my query I need to keep order in my result by the value of NM field so:
CREATE VIEW "MICHAL".SOMEVIEW AS
SELECT BRANZE.NM, PODBRANZE.NM
FROM BRANZE, PODBRANZE
WHERE (BRANZE.IDBRANZY=PODBRANZE.IDBRANZY)
GROUP BY BRANZE.NM, PODBRANZE.NM
[Quoted] Line 2 error - duplicate name of the column.
- there's written in the Oracle8 Complete Reference that even if there are no group functions in the select clause , the group by can still consolidate rows so it generally should work as order but it's not. What can I do in that case?
I appreciate any help.
Michal Piasecki
CR Media
tel: (+48)(022)690-68-62
[Quoted] e:mail - michal.piasecki_at_cr-media.com Received on Mon Dec 13 1999 - 18:33:09 CET