List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:January 2 2006 3:24pm
Subject:Re: I can't find the missing rows in a table--
View as plain text  
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

Thread
I can't find the missing rows in a table--mos31 Dec
  • Re: I can't find the missing rows in a table--Mathieu Bruneau1 Jan
  • Re: I can't find the missing rows in a table--Hank2 Jan
    • Re: I can't find the missing rows in a table--Peter Brawley2 Jan
Re: I can't find the missing rows in a table--mos2 Jan
  • Re: I can't find the missing rows in a table--Peter Brawley2 Jan