MySQL - Fehler: MULTIDELETE

[Elixier]

Hallo,

kann mir irgendjemand sagen, was ich hier falsch mache?

DELETE FROM table1 USING table1 AS t1
LEFT OUTER JOIN table2 AS t2 ON t2.id = t1.id
LEFT OUTER JOIN table3 AS t3 ON t3.id = t2.id AND t3.status_id <= 0
WHERE t1.date < '2006-6-6'

Vielen Dank

Elixier

[Elixier]

Vielleicht die Fehlermeldung noch:

Unknown table 'table1' in MULTI DELETE

Danke

[Elixier]

Die Felhlermeldung noch: Unknown table 'table1 ' in MULTI DELETE

[Hamstar]

DELETE FROM
  table1
USING
  table1 AS t1
LEFT OUTER JOIN
  table2 AS t2 ON (t2.id = t1.id)
LEFT OUTER JOIN
  table3 AS t3 ON ((t3.id = t2.id) AND (t3.status_id <= 0))
WHERE
  (t1.date < '2006-6-6')

• USING kenne ich nicht
• mal den zurückgeliefreten Fehler melden
• mal die JOINs durchdenken
• Aliasnamen überprüfen

[Elixier]

Der zurückgelieferte Fehler:
Unknown table 'table1' in MULTI DELETE