Delete entries in one table where value is equal to one in second table

Question

What I want to do is something like a JOIN but not to get a result in this case: I have a table A containing

idx | values

and a table B containing

idx | A_idx | values

Now I want to delete all these rows in A where A.idx is equal to B.A_idx. Any idea how this can be done?

score 3 · Answer 1 · answered May 22 '14 at 16:03

3

delete from A where A.idx in (select A_idx from B)

answered May 22 '14 at 16:03

PaulProgrammer

score 3 · Accepted Answer · answered May 22 '14 at 16:04

3

Try this

delete from table a
where IDX in (select a_idx from table b)

answered May 22 '14 at 16:04

PeteFoulkes

2 Answers2