Seems MySQL doesn't much like having nested joins in joins...Oops! Sorry about that. (Curse me for a MySQL novice! <g>)
OK, good. That would be more efficient, even if my way *had* worked.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 value 1 to the search script, not "Math".
I'm glad you liked it! It was an interesting question.Thanks again Bruce, my favourite type of help, a pointer but allow me to learn why it works :-)
Best of all, I think I'm a little closer to understanding joins!Excellent!
Bruce Feist
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
