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 ... ?
In response to
pgsql-sql by date
|Next:||From: Picavet Vincent||Date: 2008-08-07 17:31:16|
|Subject: enumerate groups given a certain value|
|Previous:||From: felix||Date: 2008-08-07 16:14:49|
|Subject: DELETE with JOIN|