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
