Using a view in a join statement [message #370325] |
Wed, 25 August 1999 19:19 |
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
|
|
|
|
Re: never mind [message #370333 is a reply to message #370326] |
Fri, 27 August 1999 16:58 |
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....
|
|
|