4.0.18 -> 4.1.7 LEFT JOIN problem

[Dilipan Sebastiampillai]

I moved a db from 4.0.18 to 4.1.7 and I realise that the SAME sql query 
using LEFT JOIN gives me different result.
The result from 4.0.18 does s real LEFT JOIN but 4.1.7  differs 
sometimes and I don't want that.

I think it comes from an 'optimization' .... how can I make a query 
without using the LEFT JOIN optimization of MySQL 4.1.7 ?

thanks in advance
--
Dilipan 

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