select e.code, e.name, e.depcode, d.name, e.gender from dep d, emp e
	where d.code = e.depcode
;