Hello.
Not enough information to make a conclusion. At least for me
this query didn't return any error:
mysql> create table messages(id int);
Query OK, 0 rows affected (0.02 sec)
mysql> create table message_push_notifications(message_id int);
Query OK, 0 rows affected (0.01 sec)
mysql> select 1 from messages where not exists (
select 1 from message_push_notifications
where message_id = messages.id);
Empty set (0.00 sec)
Please send 'CREATE' statements for you tables, MySQL version and
exact error message.
Herman Scheepers wrote:
> Hi
>
> Could anyone help perhaps tell me why the following
> simple query containing a sub-query gives a syntax
> error.
>
> select 1 from messages
> where not exists ( select 1 from
> message_push_notifications
> where message_id =
> messages.id)
>
>
> Thanx
> Herman
>
>
>
>
> __________________________________
> Start your day with Yahoo! - Make it your home page!
> http://www.yahoo.com/r/hs
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
