Difference between revisions of "Inner Join"
Jump to navigation
Jump to search
| Line 4: | Line 4: | ||
FROM sales INNER JOIN product | FROM sales INNER JOIN product | ||
ON sales.product_id = product.product_id; | ON sales.product_id = product.product_id; | ||
[[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | |||
Revision as of 13:55, 1 November 2017
A join of two or more tables that returns only the matched rows is called an inner join
SELECT sales.sales_date, sales.order_id, sales.product_id, product.product_name FROM sales INNER JOIN product ON sales.product_id = product.product_id;