Hello I need help This Statement does not work. MySql Version is 3.23.47. On Oracle Instance it works. What can i do ? Whitch Version do i need ? MySql 4.xx ?
MySQL 3.23.47 running on localhost SELECT A.Kommentar, A.SequenzNr from Aufgabe A LEFT JOIN Taetigkeiten ON Aufgabe.Kommentar = Taetigkeiten.Bezeichnung where inaktiv = '1' ) ; Error SQL-query : SELECT A.Kommentar, A.SequenzNr FROM Aufgabe A WHERE A.kommentar NOT IN ( SELECT Bezeichnung FROM Taetigkeiten where inaktiv = '1') LIMIT 0, 30 MySQL said: You have an error in your SQL syntax near 'SELECT Bezeichnung FROM Taetigkeiten where inaktiv = '1' ) LIMIT 0, 30' at line 1 Thanks Jens Gronau --------------------------------------------- Otto (GmbH & Co KG) Wandsbeker Straße 3-7 22172 Hamburg Jens Gronau Abt. IT-GA-DR Fon: +49 40 64617473 Fax: +49 40 64647473 mailto: Jens:[EMAIL PROTECTED] --------------------------------------------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]