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

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.