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