Re: Oracle 8.1.6 SQL Question
From: Some One Else <algernon_at_spamcop.net>
Date: Sun, 12 Aug 2001 03:45:21 GMT
Message-ID: <90FAD92FAalgernonspamcopnet_at_24.4.64.20>
Date: Sun, 12 Aug 2001 03:45:21 GMT
Message-ID: <90FAD92FAalgernonspamcopnet_at_24.4.64.20>
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