inline view

From: Hanne Iren Midttun <hannem_at_tihlde.org>
Date: Wed, 26 Mar 2003 14:27:15 +0100
Message-ID: <Pine.LNX.4.21.0303261415540.1886-100000@colargol.tihlde.org>

Hi,
I have never before created an inline view (and right now it look like I'm never going to manage to create one either..) Can somebody please tell me what I'm doing wrong. (Oracle 8.1.7.4 on AIX 4.3)

1)
select * from metatab;

  KILDE_ID NAVN

---

         1 geo_vei
         2 geo_vann
         3 geo_punkt

2)
select navn from metatab where kilde_id = 1;

NAVN

---

geo_vei

3)
select * from geo_vei;

GEOMETRI

---

rv6
rv7

4)
selcet * from (select navn from metatab where kilde_id =1);

NAVN

---

geo_vei

In my head I tought the select 3 and 4 where the same?

regards Hanne
--

Hanne Midttun
http://www.tihlde.org/~hannem

English is not my native tounge Received on Wed Mar 26 2003 - 07:27:15 CST