PROBLEMS 4.1 -> 4.0

[Jonathan Araneda]

Hi all,
i have this query:

"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.