programming-examples/sql/View/15. Write a query to create a view that finds the salesmen who issued orders on October 10th, 2012.sql
2019-11-18 14:05:53 +01:00

8 lines
281 B
SQL

/*15. Write a query to create a view that finds the salesmen who issued orders on October 10th, 2012.*/
CREATE VIEW salesmanonoct
AS SELECT *
FROM salesman
WHERE salesman_id IN
(SELECT salesman_id
FROM orders
WHERE ord_date = '2012-10-10');