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
