Android Delete Query

I'm attempting to delete all rows in one table that do not have a corresponding ID in another table. Since apparently SQLite does not support joins in deletes I am trying to do something along these lines:

    DELETE FROM my_table WHERE my_id NOT IN (SELECT _id FROM my_table2);

However, I apparently can not use rawQuery since it returns a cursor so I have to use the delete function. I'm having some trouble getting this working. Here is the query I'm trying:

    mDb.delete("m开发者_开发百科y_table", "my_id NOT IN ?", new String[]{"(SELECT _id FROM my_table2)"});

Thanks.

You shouldn't use a .rawQuery, as you stated, but you can use .execSQL() to accomplish it. I regularly use it for deletions myself.

I think the only way is to execute your select and dynamically combine your WHERE clause.

You have to use execSQL instead rawQuery because rawQuery is used for the statement that return data and execSQL is used for the statements that don't return data like DELETE