On Fri, 2006-07-28 at 07:08 +0100, C.R.Vegelin wrote: > But when I run it with INNER join is takes more than 2 hours !!! > In both cases the query applies to 9.571.220 rows matched with 0 changed. > Any idea why INNER join is so much slower ?
Inner Joins joins everything, it's like a cartesian joins Left joins will omit annything which does not exist on the Right side of the table.(meaning table data) -- Ow Mun Heng <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
