I have a bit more info. The only thing I could think of that could create a constraint problem was that the two columns being grouped on have some data in common.
ie., there could be two records like this: src dst === === 9.9.9.9 aaa bbb 9.9.9.9 >From my limited knowledge with SQL, that shouldn't cause a problem when grouping by both columns should it? To test it, I modified the query to be: select concat("s",src) as Source, concat("d", dst) as Destination, count(*) as Drops from data where (action in ('drop', 'reject')) group by Source, Destination ; And it worked, as now the above sample becomes: Source Destination === === "s9.9.9.9" "daaa" "sbbb" "d9.9.9.9" Is this a feature or a bug? Thanks. [EMAIL PROTECTED] Darryl Luff wrote: > > Can anyone please explain what the subject error means? Full details are > below. Have tried searching and not come up with anything. > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php