drop view educand_v; create view educand_v as select * from educand e where not exists(select * from subject s where not exists(select * from assign where (s_code, e_code) = (s.code, e.code) ) ) order by e.code ;