Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using IN in mySql
Thanks for your help. I'll give it a go later when I'm at home. -
Using IN in mySql
That looks like it'll work just great but my original query was slightly more complex than I let on. There should also be a WHERE clause in the nested SELECT i.e. SELECT course.grade, course.subject, quiz.id, quiz.unit, quiz.name FROM course_student INNER JOIN course ON... -
Using IN in mySql
I can't get the following query to work in mySQL. From what I've read I understood that it was a valid query. It's got nothing to do with the table/column names cause all the parts work fine on their own. If this IN syntax is not supported in mySQL, is there another way to do this? Thx. SELECT...
