COUNT --- GROUP BY --- LEFT JOIN

I am attempting to combine COUNT, GROUP BY, and LEFT JOIN.. Adopting the theme on http://www.mysql.com/doc/C/o/Counting_rows.html my goal is to display only species/sex combinations that occur more than once. Additionally I wish to include the count for each row, and some keyed field from another

Re: COUNT --- GROUP BY --- LEFT JOIN

At 2:08 -0800 2/9/02, Joe Chesak wrote: I am attempting to combine COUNT, GROUP BY, and LEFT JOIN.. Adopting the theme on http://www.mysql.com/doc/C/o/Counting_rows.html my goal is to display only species/sex combinations that occur more than once. Additionally I wish to include the count

Re: COUNT --- GROUP BY --- LEFT JOIN

At 2:08 -0800 2/9/02, Joe Chesak wrote: I am attempting to combine COUNT, GROUP BY, and LEFT JOIN.. Adopting the theme on http://www.mysql.com/doc/C/o/Counting_rows.html my goal is to display only species/sex combinations that occur more than once. Additionally I wish to include the count