On fim, 2008-08-07 at 09:14 -0700, felix(at)crowfix(dot)com wrote:
> I want to delete with a join condition. Google shows this is a common
> problem, but the only solutions are either for MySQL or they don't
> work in my situation because there are too many rows selected. I also
> have to make this work on several databases, includeing, grrr, Oracle,
> so non-standard MySQL "solutions" are doubly aggravating.
>
> DELETE FROM a WHERE a.b_id = b.id AND b.second_id = ?
>
> I have tried to do this before and always found a way, usually
>
> DELETE FROM a WHERE a.b_id IN (SELECT id FROM b WHERE second_id = ?)
did you look at DELETE FROM table1 USING table2 WHERE ... ?
gnari