Re: Oracle 8.1.6 SQL Question

If I understand your question correctly, then something like this should work:

SELECT
  CATEGORY.ID,
  CATEGORY.NAME,
  COUNT(FAQ.ID) AS CNT
FROM FAQ, CATEGORY, FAQ_CAT
WHERE
  FAQ_CAT.FAQ_ID = FAQ.ID AND
  FAQ_CAT.CAT_ID = CATEGORY.ID
GROUP BY CATEGORY.ID, CATEGORY.NAME thebear_at_antispam.stanford.edu (Barry Prentiss) wrote in <3b745dc7$0$322$8eec23a_at_newsreader.tycho.net>:

>FAQ (table)
> ID
> QUESTION
> ANSWER
>
>CATEGORY (table)
> ID
> NAME
>
>FAQ_CAT (table)
> FAQ_ID
> CAT_ID
>
>
Received on Sun Aug 12 2001 - 05:45:21 CEST