Hi,
can anyone please tell me how to use nested queries in SQLite
here is the simple for which i hav written the code,
* retrieves the id, first and last from the table TABLE1 and sortby id,
c=db.query(TABLE1, new String[] {ID, FIRST, LAST}, null, null, id, null,
null);*
but how can i write a code for the query
*retrieves the id, first and last from the table TABLE1 and sortby id, the
data should also be sorted by firstname too
*
select id, first, last from table1 where
--
Bharath B.G.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---