Posted by Cook on 10/14/94 11:37

On Fri, 6 Jan 2006 23:22:33 +0100, "Hilarion"
<hilarion@SPAM.op.SMIECI.pl> wrote:

>> 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.
>
>[ snip ]
>
>You could use LEFT OUTER JOIN and GROUP BY instead of nested SELECT.
>Something like:
>
>Hilarion

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

I write a little piece of PHP code ...

thanks.

• Next in forum: Re: Nested SELECT in SELECT clause works in MySQL 3 and not in MySQL 4
• Prev in forum: Re: Nested SELECT in SELECT clause works in MySQL 3 and not in MySQL 4
• Thread view: Re: Nested SELECT in SELECT clause works in MySQL 3 and not in MySQL 4

[Reply to this message]