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