Re: Use a join with a view and table

never mind, it does work as it is supposed to. I just messed up the SQL for the view.

thanks anyway and keep posting
Filip

Filip Hanik <fhanik_at_digitalworkforce.net> wrote in message news:9X_w3.3321$W5.277319_at_typhoon-sf.snfc21.pbi.net...
> 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
> A.ROW_ID,
> A.OU_NAME,
> B.CHILD_COUNT
> FROM
> TBL_ORG_UNIT A,
> OU_CHILD_VW B
> WHERE
> A.ROW_ID = B.ORG_UNIT_ID
>
> why doesn't this work?
>
>
>
> thanks
> Filip
> fhanik_at_digitalworkforce.net
>
>
>
Received on Wed Aug 25 1999 - 18:41:56 CDT