select * from E where not exists (select 1 from EUSER u, JNL j where u.userid=u.userid and e.eid=u.eid )

------解决方案--------------------
使用NOT EXIST和相关子查询。
代码如下：
SQL code

SELECT E.EName
FROM E
WHERE NOT EXISTS(SELECT * FROM EUSER, JNL WHERE EUSER.USERID = JNL.USERID AND EUSER.EID = E.EID);