SQL Error 1030 / Error 124 - Additional info

2004-09-04 Thread Helmut Leininger
Hi, I get an SQL Error 1030 with error 124 (MySQL error: 124 = Wrong index given to function) during the execution of the following SQL statement: select t.Datum, t.kmStand, t.kmStand - max(h.kmStand) as km, t.Betrag, round(t.Menge,1) as Liter, round(t.Menge * 100 / (t.kmStand - max(h.kmStand)),

SQL Error 1030 / Error 124

2004-09-04 Thread Helmut Leininger
Hi, I get an SQL Error 1030 with error 124 (MySQL error: 124 = Wrong index given to function) during the execution of the following SQL statement: select t.Datum, t.kmStand, t.kmStand - max(h.kmStand) as km, t.Betrag, round(t.Menge,1) as Liter, round(t.Menge * 100 / (t.kmStand - max(h.kmStand))