Re: PROBLEMS 4.1 -> 4.0
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.
Subject
Written By
Posted
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.