SQL Exercises: Find the customers along with the salesmen who works for them
SQL Query on Multiple Tables: Exercise-2 with Solution
Write a SQL statement to find the names of all customers along with the salesmen who works for them.
Sample table: customer
Sample table: salesman
SELECT customer.cust_name, salesman.name FROM customer,salesman WHERE salesman.salesman_id = customer.salesman_id;
Output of the query:
cust_name name Nick Rimando James Hoog Brad Davis James Hoog Graham Zusi Nail Knite Julian Green Nail Knite Fabian Johnson Mc Lyon Geoff Cameron Lauson Hen Jozy Altidor Paul Adam Brad Guzan Pit Alex
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a query to find those customers with their name and those salesmen with their name and city who lives in the same city.
Next: Write a SQL statement to display all those orders by the customers not located in the same cities where their salesmen live.
What is the difficulty level of this exercise?