programming-examples/Write a query to find those customers with their name and those salesmen with their name and city who lives in the same city.sql at master - programming-examples - michuIT: Everything is code

You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

6 lines

258 B

SQL

Raw Permalink Blame History

 /*Write a query to find those customers with their name and those salesmen with their name and city
 who lives in the same city.*/
 SELECT customer.cust_name,
 salesman.name, salesman.city
 FROM salesman, customer
 WHERE salesman.city = customer.city;