Herman Scheepers <[EMAIL PROTECTED]> wrote on 11/13/2005 11:53:23 AM:
> 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 > One simple explanation is that you are trying to execute that statement on a version of MySQL that doesn't have subqueries. You must be on 4.1 or greater in order to use subqueries. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
