Ok, first, please send only e-mail, we saw it the first time. Second, MySQL does not support nested queries or sub selects or what you are using. Please see the JOIN syntax in the MySQL documenation:
http://www.mysql.com/doc/J/O/JOIN.html nickg -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ben Edwards Sent: Thursday, March 28, 2002 9:39 AM To: [EMAIL PROTECTED] Subject: where exists sql problem having problems working out sql where exists syntax. Tried query 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 --------------------------------------------------------------------- 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