Re: COUNT Problem

[Frederic Wenzel]

> >A subselect may help:
> >[...]
> >Don't know ATM if it can be done more easily, but a query like this
> >should probably work.
> >
> It can be done without a sub-query:
> [...]
> 
> That *should* work, barring any typos or ommisions I may have made. I
> used LEFT JOIN because of personal preference, it can be done other way(s).

Ah yes, I see. Nice idea. As JOINs perform better than subselects
IIRC, your solution ought to be preferred, then.

Fred