Re: DELETE with JOIN

On fim, 2008-08-07 at 09:14 -0700, felix@crowfix.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