Join 3 Tables

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;