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