drop view emp_v;
create view emp_v as
	select e.code as empcode, e.name as empname, e.depcode, d.name as depname, e.gender
		from dep d, emp e
		where d.code = e.depcode
;