Write a query to join orders table to customer and salesman table and attributes are mentioned above tables. The result will be as displayed in orders table. Tables Attached
Attachments:
Answers
Answered by
0
Answer:
1. SELECT * FROM orders INNER JOIN customer ON order.customer_id=customer.customer_id INNER JOIN salesman ON salesman.salesman_id=order.salesman_id;
Explanation:
Similar questions