programming-examples/2. Write a query to display all the orders for the salesman who belongs to the city London.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.

7 lines

224 B

SQL

Raw Permalink Blame History

 /*2. Write a query to display all the orders for the salesman who belongs to the city London.*/
 SELECT *
 FROM orders
 WHERE salesman_id =
     (SELECT salesman_id
      FROM salesman
      WHERE city='London');