从Android应用程序表中删除行比较其他表

Question

我有两个表A和B

A has aid, bid, aname columns 
B has bid, bname columns 

我想从

即delete from A where bid = (select bid from b where bname like '%Mass%')

我该怎么写，删除一行在Android中查询。

我可以单独执行select bid from b where bname like '%Mass%'一件事，并将id存储在一个变量中，并运行class database的delete方法。

有没有其他简单的方法。

Answer 1

DELETE FROM A WHERE bid IN (SELECT bid FROM B WHERE bname LIKE '%Mass%')