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
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
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]
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
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
should be a piece of
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 should