Difference between revisions of "Natural Join"

From rbachwiki
Jump to navigation Jump to search
(Created page with "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_...")
 
 
Line 3: Line 3:
  FROM employees NATURAL JOIN jobs
  FROM employees NATURAL JOIN jobs
  WHERE department_id > 80
  WHERE department_id > 80
SELECT sales_date, order_id, product_id
FROM sales NATURAL JOIN product;
This join will return columns from the employees table and their job_title from the jobs table based on the common column job_id
This join will return columns from the employees table and their job_title from the jobs table based on the common column job_id


[[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]]
[[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]]

Latest revision as of 19:28, 1 November 2017

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
SELECT sales_date, order_id, product_id
FROM sales NATURAL JOIN product;

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