From: Peter Brawley
Date: January 2 2006 3:24pm
Subject: Re: I can't find the missing rows in a table--
List-Archive: http://lists.mysql.com/mysql/193414
Message-Id: <43B94593.9070801@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Mike,

 >I ended up using a subselect and that found the missing rows.
 >I'm not sure why the left join didn't work. I've been using them
 >for years to find missing rows in tables.

I think that suggests one of the indexes was munged.

PB

mos wrote:

> At 08:33 PM 1/1/2006, Hank wrote:
>
>> Don't you want the queries to be "outer join" and not "left join"?
>
>
> A "left join" is a "left outer join".
> I ended up using a subselect and that found the missing rows. I'm not 
> sure why the left join didn't work. I've been using them for years to 
> find missing rows in tables.
>
> Mike 
>


-- 
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