[thelist] How do I SELECT for the following...
r937
rudy at r937.com
Thu Feb 4 16:57:43 CST 2010
> you can efficiently support the parent-child model:
phil, that's awesome
could you show examples applied to the original problem?
EXERCISES
exerciseID
exerciseTitle
SEARCHTAGS
searchtagID
parentID ( -> searchtagID)
searchtag
EXERCISESEARCHTAGS
exerciseID (Foreign key -> EXERCISES)
searchtagID (Foreign key -> SEARCHTAGS)
if you cannot do it for all three databases you cited, please show at least
one solution
i for one would welcome the sql tutorial...
;o)
More information about the thelist
mailing list