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@news.tpnet.pl>

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 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
e:mail - michal.piasecki_at_cr-media.com Received on Mon Dec 13 1999 - 11:33:09 CST