At 10:31 AM -0700 8/13/01, Barry Prentiss wrote:
>Thx Again Alnisa,
>  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;
>

Funny, I think I just sent you something somewhat similar. Glad it worked.

Alnisa
-- 
   .........................................
    Alnisa  Allgood
    Executive Director
    Nonprofit Tech
    (ph) 415.337.7412  (fx) 415.337.7927
    (url)  http://www.nonprofit-techworld.org
    (url)  http://www.nonprofit-tech.org
    (url)  http://www.tech-library.org
   .........................................
    Nonprofit Tech E-Update
    mailto:[EMAIL PROTECTED]
   .........................................
    applying technology to transform
   .........................................

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to