jantichap

select luser.userid,luser.firstname,luser.lastname from luser where luser.Pos = \'Teacher\'and luser.userid not in (select sectionuser.userid from sectionuser where sectionuser.courseid = \'204105\'and sectionuser.SectionID = \'1\' and sectionuser.Semester = \'2\') ORDER BY luser.UserID this query i can use in other database server but i can\'t use in MySQL version 4.0.2-alpha-nt please!!! help me to convert my query can use in MySQL ....thank