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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
