Hi (Sorry by my english, i speak spanish)
I have problem with a Query. It does not recognize EXISTS nor IN nor NOT IN My version is MySQL 4.0.11a-gamma But I do not know if it recognizes those clauses. I have dealed with the two forms: 1. SELECT usu_id FROM usuario WHERE NOT EXISTS (SELECT * FROM grupo WHERE usuario.g_id=grupo.g_id AND grupo.g_id > 5) 2. SELECT usu_id FROM usuario WHERE g_id NOT IN (SELECT g_id FROM grupo WHERE grupo.g_id > 5) Thanks by your help. Juan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]