>>>>> "John" == John Siracusa <[EMAIL PROTECTED]> writes:
John> You need the DISTINCT part if you join with any ...-to-many John> relationship. I'm not sure in your example if the DISTINCT should John> have been there, but I can imagine cases where it will need to be John> there, so we need some way to do it. What you need is COUNT(DISTINCT some_function_that_joins_all_args(arg, arg)) because you really want "4,5" to be counted distinctly from "4,6". So coalesce definitely doesn't do it. -- Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095 <[EMAIL PROTECTED]> <URL:http://www.stonehenge.com/merlyn/> Perl/Unix/security consulting, Technical writing, Comedy, etc. etc. See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training! ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
