Posted by Hilarion on 01/09/06 12:55

>>> I have a problem to migrate a software to MySQL 4 the request below
>>> works perfectly with MySQL 3 and not with MySQL 4. If somebody jave
>>> any idea.

>> You could use LEFT OUTER JOIN and GROUP BY instead of nested SELECT.
>> Something like:

> OK, thank you for your help but it's to complex for me (the original
> request have 4 nested select)

You could post that select here - maybe we can help to make it
simple.


> I write a little piece of PHP code ...

This may make it much slower.


HIlarion

[Back to original message]