[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