Not too sure about the performance difference of using a subselect in MySQL vs. join deletes. I think we'd prefer to see a divergence of the two systems here. One for ANSI SQL and the exceptional case which is MySQL AFAIK.