sql where exists

2002-03-28 Thread Ben Edwards
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

Re: sql where exists

2002-03-28 Thread Alex Kitainik
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