MySQL Forums
Forum List  »  Newbie

Re: PROBLEMS 4.1 -> 4.0
Posted by: Felix Geerinckx
Date: June 08, 2005 11:26AM

Jonathan Araneda wrote:

> "SELECT id_pais, nom_pais FROM paises WHERE id_pais IN(SELECT id_pais FROM pbs GROUP BY
> id_pais)"
>
> in the version 4.1 i have no problems, but in the 4.0 i get this message:
>
> "ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your
> MySQL server version for the right syntax to use near 'SELECT p.id_pais id FROM pbs p)' at line 1"
>
> and i don't know what is the ploblem.

The problem is that MySQL 4.0 does *not* support subqueries.

--
felix
Please use BBCode to format your messages in this forum.

Options: ReplyQuote


Subject
Written By
Posted
June 08, 2005 11:22AM
Re: PROBLEMS 4.1 -> 4.0
June 08, 2005 11:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.