What the hell this query do!? SELECT student.name FROM student WHERE not exists( SELECT * FROM enrollment WHERE not exists( SELECT * FROM class WHERE class.name = enrollment.classname AND enrollment.studentnumber = student.sid )
) It returns the name of the students which are enrolled in a class? I need to know what returns in order to translate it into SQL that mysql can parse... Any help would be appreciated! Roberto Ramírez --------------------------------------------------------------------- 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