8.05.2017: andmebaasirakenduste arendaja x3 (Väino L.)

select e.first_name, e.last_name, d.department_name from employees e inner join departments d on e.department_id = d.department_id

https://vainol.kehtna.edu.ee/sql/SQL_SELECT.pdf

http://www.sql-join.com/sql-join-types

SELECT d.department_id, e.last_name FROM
employees e, departments d WHERE
e.department_id=d.department_id(+) and
e.employee_id>170 ORDER BY d.department_id;

SELECT d.department_id, e.last_name FROM
employees e RIGHT JOIN departments d on e.department_id = d.department_id and e.employee_id>170

ORDER BY d.department_id;

select region_id, region_name, job_id, job_title from regions cross join jobs

right join ja right outer join teevad sama
full join
left join

cross join korrutab