programming-examples/1. Write a query to display all the orders from the orders table issued by the salesman 'Paul Adam'.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

236 B

SQL

Raw Permalink Blame History

 /*1. Write a query to display all the orders from the orders table issued by the salesman 'Paul Adam'.*/
 SELECT *
 FROM orders
 WHERE salesman_id =
     (SELECT salesman_id
      FROM salesman
      WHERE name='Paul Adam');