Search:

Sorry, I purposely made that mistake--I deliberately wrote faulty code, that would give you rubbish when executed. (Your original code is correct!)
I was wondering if SQL would allow it to go...

OK, INNER JOIN seems the way to go. Does it prevent you from inner joining where neither field references the other, eg

...
INNER JOIN students_classes AS sc ON sc.class_id = c.id
INNER...

I've finally got MySQL working on my local server, and I use phpMyAdmin 2.5.1 to make DB's.
I've created a small set of relational tables in a test database (excuse my terminology if it's wrong),...