[thelist] one-to-many join problem

thelist at cjmarsh.com thelist at cjmarsh.com
Sat Jan 14 18:51:05 CST 2006



> This is tough because if you use count(), which is what one 
> woudl think of first, it won't work, because you need 
> count()s of records with different filters applied. You would 
> need three queries in this case, one filtering on 
> longdistance=true, another filtering on dsl=true, and another 
> filtering on callerid=true.

Yes, I didn't really think my solution through adequately in my enthusiasm
to respond :)



Chris Marsh

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.16/225 - Release Date: 09/01/2006

More information about the thelist mailing list