I have a database that has two tables, being EstoqueDBQ
and FilaDBQ
, I need to create the following logic.
If the value exists in the FilaDBQ table and in stoqueDBQ , this value should be excluded from FilaDBQ, I thought I'd use the code below, but I'm having trouble adapting .
String sql = "SELECT UM FROM FilaDBQ [.....]";
Cursor data = database.rawQuery(sql, null);
if (cursor.moveToFirst()) {
Se é verdade, apagar o valor na tabela FilaDBQ
} else {
Se não, nada acontece.
}