programming-examples/2. Write a query to display distinct salesman and their cities.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

166 B

SQL

Raw Permalink Blame History

 /*2. Write a query to display distinct salesman and their cities.*/
 SELECT salesman_id, city
 FROM customer
 UNION
 SELECT salesman_id, city
 FROM salesman;