Ben Balbo wrote:
Seems MySQL doesn't much like having nested joins in joins...
Oops! Sorry about that. (Curse me for a MySQL novice! )
However, your principles led me to my result. As the search page will
pass the class ids in anyway, I don't need to read these from the
table. I.E. I pass the
Ben Balbo wrote:
Teacher (id, name, ...)
TeacherClass (teacherid, classid, timestamp)
Class (id, name, ...)
Now, what I'd really like to do it find all teachers who, for example,
taught Engligh and Math, but not Biology,
Here's a general, recursive, untested solution for you to play with.
We st
