gsk wrote: > I am trying to join two tables in the Android SQlite DB but looks > like SQlite does not support foreign key relationships.
http://www.sqlite.org/syntaxdiagrams.html#table-constraint > I am sure other people must be using multiple tables in their > Android app, how do you join them? Joining does not require foreign key relationships. All foreign key relationships do is enforce referential integrity. So, you join tables in SQLite the same way you do in any other SQL-based database. -- Mark Murphy (a Commons Guy) http://commonsware.com _The Busy Coder's Guide to Android Development_ Version 1.9 Available! --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---

