Oracle 31.10.2014

select first_name nume, department_name departament, city oras , country_name tara, region_name regiune
from employees join departments using (department_id)  join locations using (location_id) join countries using (country_id)
join regions using (region_id) order by 2

select first_name nume, department_name departament, city oras , country_name tara, region_name regiune
from employees e,departments d,locations l,countries c,regions r
where e.department_id=d.department_id and d.location_id=l.location_id and l.country_id=c.country_id and c.region_id=r.region_id order by 2