Natural Join

A natural join is based on all columns in two tables that have the same name and selects rows from the two tables that have equal values in all matched columns

SELECT  first_name, last_name, job_id
FROM employees NATURAL JOIN jobs
WHERE department_id > 80

This join will return columns from the employees table and their job_title from the jobs table based on the common column job_id

Back To Top- Home - Category