|
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
Navigation:
[Reply to this message]
|