Hi

Actually it was MySQL 5 issue, but I was looking for high traffic forums, so i put it here.

Thanks

Thank you so much. You're right. My left join was not correct, because doing this:

FROM (test1 t1) LEFT JOIN (test3 t3, test2 t2)

ON (t1.id=t2.id AND t1.id=t3.id)

I actually forced SQL Server...