SQL Exercises: Make a join on the tables salesman, customer and orders in such a form that the same column of each table will appear once and only the relational rows will come

SQL JOINS: Exercise-7 with Solution

Write a SQL statement to join the tables salesman, customer and orders so that the same column of each table appears once and only the relational rows are returned.

Sample table: orders

Sample table: customer

Sample table : salesman

Sample Solution:

SELECT * 
FROM orders 
NATURAL JOIN customer  
NATURAL JOIN salesman;

Output of the Query:

salesman_id	city		customer_id	ord_no	purch_amt	ord_date	cust_name	grade	name		commission
5005		London		3001		70009	270.65		2012-09-10	Brad Guzan		Pit Alex	0.11
5001		New York	3002		70002	65.26		2012-10-05	Nick Rimando	100	James Hoog	0.15
5001		New York	3007		70005	2400.60		2012-07-27	Brad Davis	200	James Hoog	0.15
5001		New York	3002		70008	5760.00		2012-09-10	Nick Rimando	100	James Hoog	0.15
5006		Paris		3004		70010	1983.43		2012-10-10	Fabian Johnson	300	Mc Lyon		0.14
5001		New York	3002		70013	3045.60		2012-04-25	Nick Rimando	100	James Hoog	0.15

Relational Algebra Expression:

Relational Algebra Tree:

Explanation:

Pictorial presentation:

Practice Online

Query Visualization:

Duration:

Rows:

Cost:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a SQL statement to find the details of a order i.e. order number, order date, amount of order, which customer gives the order and which salesman works for that customer and commission rate he gets for an order.
Next: From the following tables write a SQL query to display the cust_name, customer city, grade, Salesman, salesman city. The result should be ordered by ascending on customer_id.