I haven't tested this but it should be something like... select child.* from child join association on child.guid = association.child_guid where association.parent_guid = ?
And of course, you should change child.* to be whatever columns you need and the ? should be your particular parent guid. On Apr 6, 10:24 am, SnowDrifter <[EMAIL PROTECTED]> wrote: > I am trying to figure out how to create a where clause (I think that > is what I need) to filter one table with the data from another table. > > I have three tables. One is for "parents" one is for "children" and > one is for associations between these two tables. The way I have done > this is using GIUD identifiers to identify the parents and children. > In the association table I just have GUID pairs to show the > association. > > So a parent or child table might look like so: > GUID, title, data > > and the association table might look like so: > GUID(parent), GUID(child) > > so I want to be able to do a query that does a query against the child > table and returns only a cursor of children that are associated with a > particular parent. > > I can't seem to find any good tutorials on how to do such a thing. --~--~---------~--~----~------------~-------~--~----~ 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] Announcing the new M5 SDK! http://android-developers.blogspot.com/2008/02/android-sdk-m5-rc14-now-available.html For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---
