Re: Another SQL Question
| From: | Alnisa Allgood | Date: | Mon, 13 Aug 2001 17:48:45 +0000 |
| Subject: | Re: Another SQL Question | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-11305@lists.php.net to get a copy of this message | ||
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:nonprofit-tech-subscribe@egroups.com ......................................... applying technology to transform .........................................