this could only have come up in mysql, by the way
writing this (which is what you had) --
select a, b, c, count(*) ... group by a, b
is invalid in all other databases
you will find that in the result set, there will be one row for each
combination of a,b, but the value for c in the results is unpredictable
see
GROUP BY and HAVING with Hidden Fields
http://dev.mysql.com/doc/refman/5.0/en/group-by-hidden-fields.html
however, in your case what you actually wanted was this after all --
select a, b, c, count(*) ... group by a, b, c
so you're okay
;o)
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: wdvltalk@lists.wdvl.com
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: archive@jab.org
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
