Oracle SQL Joins - Inner Join, Equi Join. Natural Join, Self Join (ANSI Syntax)
Follow this link to join my WhatsApp group: https://chat.whatsapp.com/B5GcKYHlPZw...
Oracle SQL Joins - Inner Join, Equi Join. Natural Join, Self Join (ANSI Syntax)
SQL Queries used:
-----------------------------------
SET LINES 300
set ECHO ON
SELECT e.employee_id, e.first_name, d.department_name, e.salary
FROM employees e INNER JOIN departments d
ON e.employee_id -gt d.manager_id
WHERE d.manager_id = 200;
pause
SELECT e.employee_id, e.first_name, d.department_name, e.salary
FROM employees e JOIN departments d
ON e.employee_id = d.manager_id;
pause
SELECT e.employee_id, e.first_name, d.department_name, e.salary
FROM employees e JOIN departments d
ON e.department_id = d.department_id
WHERE d.department_id -lt 50;
pause
SELECT e.employee_id, e.first_name, d.department_name, e.salary
FROM employees e JOIN departments d
USING(department_id)
WHERE department_id -lt 50;
pause
SELECT e.employee_id, e.first_name, d.department_name, e.salary
FROM employees e NATURAL JOIN departments d;
pause
SELECT emp.employee_id, emp.first_name employee_name, emp.manager_id, mgr.employee_id, mgr.first_name manager_name
FROM employees emp JOIN employees mgr
ON emp.manager_id = mgr.employee_id
WHERE UPPER(emp.first_name) LIKE 'R%';
pause
set lines 80
desc employees
pause
set lines 80
PROMPT ' Non-ANSI Syntax .....'
SELECT e.employee_id, e.first_name, d.department_name, e.salary
FROM employees e , departments d
WHERE e.department_id = d.department_id
AND d.department_id -lt 50;
pause