Re: I can't find the missing rows in a table--

[mos]

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  


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]