Why not just use a JOIN? On Sep 14, 6:01 am, Samuh <[email protected]> wrote: > 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
