Take a look at this (contrived) query, as might be passed to [
SQLiteDatabase.rawQuery()](
http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#rawQuery
(java.lang.String, java.lang.String[])):
SELECT *
FROM t1 A, (SELECT T2.id FROM t2 T2) B
WHERE A.id = B.id
On Android 2.