I wish to execute the following query on my application's SQliteDatabase. String sql = "Select col_1,row_id from Table1 where row_id IN(Select row_id from Table2 where key = 'key')"
I am using the rawQuery function of the SQLiteDataBase class for the same. The problem is when the inner query returns 0 objects the query runs and returns 0 results. But when the inner query returns a set the query is not executed. Can we have nested queries like these in rawQuery? What is it that I am missing here? Please help. Thanks. -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
