>Student | Class >-------------------------- >Steve Lefevre | Math101 >Stacy Adams | Intro to SQL
>Something like >SELECT Student.Name, Classes.Name FROM Students, Classes WHERE >Students.StudentID = " . $ID . " AND Classes.Name IN ( SELECT Classes.Name >FROM Classes WHERE ClassID = Students.ClassID ) Try SELECT Student.Name, Classes.Name FROM Students, Classes WHERE Students.ClassID = Classes.ClassID. If you only wnat it for one syudent do: SELECT Student.Name, Classes.Name FROM Students, Classes WHERE Students.ClassID = Classes.ClassID AND Students.StudentID = '<some ID>' Hope this helps. Scott Pippin [EMAIL PROTECTED] --------------------------------------------------------------------- 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
