Re: Oracle 8.1.6 SQL Question
Date: Mon, 13 Aug 2001 10:28:52 -0700
Message-ID: <3b780eb8$0$323$8eec23a_at_newsreader.tycho.net>
Thx Algernon,
You were very close, and instrumental in solving this seemingly simple
query problem.
The actual query that worked looks like this:
SQL> select cat.id, cat.name, count(faq_cat.cat_id) as num
2 from mdfaq_faq_cat faq_cat, mdfaq_category cat
3 where faq_cat.cat_id (+) = cat.id
4 group by cat.id, cat.name;
ID NAME
---------- ---------------------------------------------------------------- NUM ---------- 1 Applications 0 2 Solid Edge 0 4 MicroStation 1
Thx for your help,
Barry
"Some One Else" <algernon_at_spamcop.net> wrote in message
news: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 Mon Aug 13 2001 - 19:28:52 CEST