Home » RDBMS Server » Server Administration » Using a view in a join statement
Using a view in a join statement [message #370325] Wed, 25 August 1999 19:19 Go to next message
Filip Hanik
Messages: 2
Registered: August 1999
Junior Member
I have a view, OU_CHILD_VW with two fields (ORG_UNIT_ID and CHILD_COUNT) which counts all the children per org unit from a ORG_UNIT table.
Now I simply want to say something like this

SELECT
ROW_ID,
CHILD_COUNT
FROM
TBL_ORG_UNIT,
OU_CHILD_VW
WHERE
TBL_ORG_UNIT.ROW_ID = OU_CHILD_VW.ORG_UNIT_ID

why doesn't this work?

thanks
Filip
never mind [message #370326 is a reply to message #370325] Thu, 26 August 1999 12:49 Go to previous messageGo to next message
Filip Hanik
Messages: 2
Registered: August 1999
Junior Member
never mind,
my view was setup incorrectly
thanks
anyway
Re: never mind [message #370333 is a reply to message #370326] Fri, 27 August 1999 16:58 Go to previous message
Virlitz
Messages: 2
Registered: August 1999
Junior Member
But if your view as an aggregate function, you can't select it with a rowid column, because rowid refers to the actual row block position....
Previous Topic: dynamic pl/sql question
Next Topic: two-dimensional pl/sql table
Goto Forum:
  


Current Time: Sat Oct 24 03:58:48 CDT 2020