From: Hank Date: January 2 2006 2:34am Subject: Re: I can't find the missing rows in a table-- List-Archive: http://lists.mysql.com/mysql/193402 Message-Id: <1990a96b0601011834n2c083970ic542f2baf63aa13c@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Don't you want the queries to be "outer join" and not "left join"?