From: Paul Halliday Date: November 4 2010 6:02pm Subject: Re: Missing results. List-Archive: http://lists.mysql.com/mysql/223508 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 > Presumably those records were absorbed into your 'group by' clause, since there was an entry, from a later time, which had the same values for all the group by fields. > > > -- > Simcha Younger > Geez, how obvious. I was thinking on a completely different plane. I feel pretty silly now. :) Thanks.