From: Peter Brawley Date: January 2 2006 3:22pm Subject: Re: I can't find the missing rows in a table-- List-Archive: http://lists.mysql.com/mysql/193413 Message-Id: <43B9451D.7080201@earthlink.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hank wrote: >Don't you want the queries to be "outer join" and not "left join"? ??? A left join IS an outer join. PB -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.9/217 - Release Date: 12/30/2005