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 w
Hank wrote:
Don't you want the queries to be "outer join" and not "left join"?
??? A left join IS an outer join.
PB
--
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
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 r
Don't you want the queries to be "outer join" and not "left join"?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mos a écrit :
> This should be so simple, yet I've struck out.
>
> I have 2 tables, each with a common column called "pid" which is an
> integer and is a unique index. There are approx 18 million rows in each
> table, and one of the tables has approx 5000 fewer rows than the other
> table. So it s
