Select with inner join NOT IN / IN

2003-12-12 Thread Gronau, Jens
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 = Taetigke

Mysql Error 1065

2003-12-23 Thread Gronau, Jens
Hello I need help MySQL 3.23.47 running on localhost linux I want to create an Test Instance. Based on my Production Instance. My Batch (it has work for month) head prax2test.sh time mysqldump -u transfer -ptransfer timesheet > timesheet.temp echo "drop database timetest;" > timetest.sql echo "