question Re: phoenix delete based on joins in Archives of Support Questions (Read Only)

phoenix delete based on joins

arunpoy — Thu, 21 Jul 2016 21:42:51 GMT

I need to delete records on a phoenix table based on the join with another phoenix table. Is it possible?

If so can anyone provide the syntax. i dont see a direct way of doing this

asinghal — Fri, 22 Jul 2016 00:43:57 GMT

Some join queries can be rewritten like this:-

delete from source1 where (pk1,pk2) in (select pk1,pk2 from source2);

arunpoy — Fri, 22 Jul 2016 11:57:00 GMT

Thanks Ankit, it works. but is it the effective way if we have large number of rows. AS we are using an IN condition in the query.