Syntax error when using except in a query
I don’t believe MySQL supports EXCEPT syntax. Try using NOT IN or a LEFT JOIN: SELECT s.sno FROM students s WHERE s.sno NOT IN ( SELECT t.sno FROM take t WHERE t.cno = ‘CS112’ ); OR SELECT s.sno FROM students s LEFT JOIN take t ON s.sno = t.sno WHERE IFNULL(t.cno, ”) != ‘CS112’ UPDATE … Read more