Android SQLite MINUS query
<p>I am trying to initialize a cursor with values from a query. The query is meant to return contents of table 1 that are not in table 2. For this I have used the <code>MINUS</code> clause but it doesnt seem to be working and I cannot see where I have gone wrong.</p>

<p><strong>Query</strong></p>

<pre><code>return db.rawQuery("select _id, ingredient_name, measurement, unit from ingredients where recipe_code = " + recipe_code +
            " MINUS select ingredient_name, measurement, unit from kitchen", null);
</code></pre>

<p><strong>Error</strong></p>

<pre><code>02-05 11:35:05.189 29028-29028/com.example.rory.prototypev2 E/AndroidRuntime: android.database.sqlite.SQLiteException: near "MINUS": syntax error (code 1): , while compiling: select _id, ingredient_name, measurement, unit from ingredients where recipe_code = 11 MINUS select ingredient_name, measurement, unit from kitchen
</code></pre>