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]