[EMAIL PROTECTED] wrote: > > Using MySQL-4.0.15 > > For whatever reason I cannot use the following query in Cold Fusion or > Inside the control center for MYSQL or from the command line mysql. > > Here is my query: > > SELECT * FROM dbwebmaster d2 > WHERE (menuid <> 0 AND website='CMS_INFORMATION' AND parentref = 4 AND > haschildren =1) AND (EXISTS(SELECT * FROM dbwebmaster d3 WHERE parentref = > d2.menuid)) > > HERE is the ERROR Message: > > Syntax error or access violation: You have an error in your SQL syntax. > Check the manual that corresponds to your MySQL server version for the > right syntax to use near 'EXISTS(SELECT * FROM dbwebmaster d3 WHE > > What's wrong with this query?? I've been using EXISTS for some time now > but not with MySQL. >
EXISTS is supported in MySQL from version 4.1. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]