Difference between revisions of "Join 3 Tables"
Jump to navigation
Jump to search
(Created page with " SELECT A.sales_date, A.order_id, A.product_id, B.product_name, C.job_title FROM sales A INNER JOIN product B ON A.product_id = B.product_id LEFT OUTER JOIN salesperson C...") |
|||
| Line 4: | Line 4: | ||
LEFT OUTER JOIN salesperson C | LEFT OUTER JOIN salesperson C | ||
ON A.salesperson_id = C.salesperson_id; | ON A.salesperson_id = C.salesperson_id; | ||
[[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | |||
Revision as of 19:55, 1 November 2017
SELECT A.sales_date, A.order_id, A.product_id, B.product_name, C.job_title FROM sales A INNER JOIN product B ON A.product_id = B.product_id LEFT OUTER JOIN salesperson C ON A.salesperson_id = C.salesperson_id;