Thx Alnisa,
I had tried your suggested approach earlier.
I just tried it again I got the following from SQL*Plus:
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production
JServer Release 8.1.6.3.0 - Production
SQL select cat.id, cat.name, count(faq_cat.cat_id) as num_id
2
At 9:29 AM -0700 8/13/01, Barry Prentiss wrote:
Thx Alnisa,
I had tried your suggested approach earlier.
I just tried it again I got the following from SQL*Plus:
Wow, Oracle, what a pain. (Actually, it's probably pure laziness that
MySQL doesn't check for this, but anyway). Anyway, I looked
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,