select TBL_EMPLOYEES.EMP_CODE, TBL_EMPLOYEES.EMP_NAME, TBL_DEPT.DEPT_CODE, TBL_DEPT.DEPT_NAME
from TBL_EMPLOYEES
full join TBL_DEPT
on TBL_EMPLOYEES.DEPT_CODE = TBL_DEPT.DEPT_CODE
order by TBL_EMPLOYEES.EMP_CODE asc, TBL_DEPT.DEPT_CODE asc;