Help query with MySQL 4.0.11

2004-03-24 Thread WebMaster Informática007
Hi I have problem with a Query. It does not recognize EXISTS. My version is MySQL 4.0.11a-gamma The query is: SELECT U.usu_id, U.usu_login FROM cva_usuario U WHERE NOT EXISTS (SELECT * FROM cva_grupo_usuario GU WHERE GU.usu_id=U usu_id Where GU.gru_id=4) Help please.

Re: Help query with MySQL 4.0.11

2004-03-24 Thread Paul DuBois
At 21:44 -0400 3/24/04, WebMaster Informática007 wrote: Hi I have problem with a Query. It does not recognize EXISTS. My version is MySQL 4.0.11a-gamma Subqueries are supported beginning with MySQL 4.1.0. http://www.mysql.com/doc/en/Subqueries.html

Re: Help query with MySQL 4.0.11

2004-03-24 Thread Michael Stassen
Paul DuBois wrote: At 21:44 -0400 3/24/04, WebMaster Informática007 wrote: Hi I have problem with a Query. It does not recognize EXISTS. My version is MySQL 4.0.11a-gamma Subqueries are supported beginning with MySQL 4.1.0. http://www.mysql.com/doc/en/Subqueries.html