Re: [sqlite] using cross-link table

2005-03-26 Thread Mrs. Brisby
On Sat, 2005-03-26 at 10:29 -0500, Jason Jobe wrote: > // to find people whose great-grandfather's name is Fred > Well, this is probably correct sql but hopefully you get the idea. So > part of the question is: > > 1. How efficient is this? Not at all. It doesn't work. If you meant:

[sqlite] using cross-link table

2005-03-26 Thread Jason Jobe
I'm a big fan of EOF (Apple's relational to OO tool) and I've been trying to figure out the easiest/best way to support queries that span several links through a many-to-many cross-link table and am hoping for some suggestions and pointers. Here is the kind of query I would like to write (or somet