-- implicit join
/*
select 
	e.empno as "ID", 
	INITCAP(e.ename) as "NAME", 
	INITCAP(d.dname) as "DEPT.", 
	INITCAP(d.loc) as "LOCATION"
from 
	emp e, dept d
where 
	e.deptno = d.deptno
order by
	d.loc;
*/
-- explicit join


SELECT
	e.empno,
	e.ename,
	d.dname,
	d.loc
FROM
	emp e INNER JOIN dept d
ON
	e.deptno = d.deptno
ORDER BY
	d.loc;