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
-~----------~----~----~----~------~----~------~--~---

Reply via email to