Use a join with a view and table

From: Filip Hanik <fhanik_at_digitalworkforce.net>
Date: Wed, 25 Aug 1999 16:25:27 -0700
Message-ID: <9X_w3.3321$W5.277319@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:25:27 CDT