mySQL does not support nested 'selects'. Read the manual, please :)

Ben Edwards wrote:

> having problems working out sql where exists syntax.
>
> Tried
>   select *
>   from   sections s
>   where  exists (
>                 select 0
>                 from   pages s
>                 where s.page = p.page
>                 )
>
> Any ideas,
> Ben
> --
> [EMAIL PROTECTED]                +44 (0)7970 269 522
> http://www.subvertise.org           -- Altering the Corporate Image
> http://www.criticaldistribution.org -- Buy Alternative Video Online
> http://www.videonetwork.org         -- Community/Radical Video
> http://www.spamcop.net/             -- Killing SPAM feels good!
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

--
Alex Kitainik



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to