SELECT last_name, department_name dept_name
FROM employees, departments;
SELECT table1.column, table2.column
FROM table1,table2
WHERE table1.column1 = table2.column2 ;
SELECT employees.employee_id,
employees.department_id,
departments.department_id,
departments.location_id
FROM employees, departments
WHERE employees.department_id = departments.department_id ;
Use AND for additional search conditions
SELECT e.employee_id, e.last_name, e.department_id, d.department_id,d.location_id
FROM employees e, departments d
WHERE e.department_id = d.department_id
AND e.salary > 5000;
SELECT last_name, salary, grade_level
FROM employees, job_grades
WHERE salary BETWEEN 5000 AND 10000 ;
SELECT column names from both tables
FROM table name 1
LEFT|RIGHT|FULL OUTER JOIN table name 2 on condition;
SELECT e.last_name, e.department_id,d.department_name
FROM employees e,departments d
WHERE e.department_id(+) = d.department_id ;
SELECT e.first_name,e.last_name,e.salary,d.department_id ,d.department_name
FROM employees e
LEFT OUTER JOIN departments d ON (e.department_id = d.department_id) ;
SELECT e.first_name,e.last_name,e.salary,d.department_id ,d.department_name
FROM employees e
RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id) ;
SELECT e.first_name,e.last_name,e.salary,d.department_id ,d.department_name
FROM employees e
FULL OUTER JOIN departments d ON (e.department_id = d.department_id) ;
SELECT worker.last_name|| ‘ works for ‘ || manager.last_name
FROM employees worker, employees manager
WHERE worker.manager_id = manager.employee_id ;
SELECT first_name,department_name
FROM employees
CROSS JOIN departments ;
SELECT employee_id,
first_name,
manager_id,
department_name
FROM employees
NATURAL JOIN departments ;
SELECT employee_id,
first_name,
manager_id,
department_name
FROM employees
JOIN departments
USING (department,manager_id);
Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.
Comments (0)