Bosconian wrote:
> Can someone explain why the following query will return 80 records:
>
> SELECT DISTINCT c.caseid FROM cases c LEFT JOIN casespecialty cs ON c.caseid
> = cs.caseid LEFT JOIN examspecialty es ON c.caseid = es.caseid WHERE (cs.uid
> = 86 OR es.uid = 86)
>
> but when c.caseid is wrapped with Count() the query will return 225:
>
> SELECT DISTINCT Count(c.caseid) FROM cases c LEFT JOIN casespecialty cs ON
> c.caseid = cs.caseid LEFT JOIN examspecialty es ON c.caseid = es.caseid
> WHERE (cs.uid = 86 OR es.uid = 86)
>
> The correct answer in this case is 80. I'm looking for Count() to return the
> correct (desired) total.
>
>

Do you want a distinct count, or a count of distinct items?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================