Difference between revisions of "Inner Join"
Jump to navigation
Jump to search
(Created page with "'''A join of two or more tables that returns only the matched rows is called an inner join'''") |
|||
| Line 1: | Line 1: | ||
'''A join of two or more tables that returns only the matched rows is called an inner join''' | '''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; | |||
Revision as of 13:54, 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;