SQL Note: Note 9 use subquery

Subquery is a query nested in other queries. 1. Use subqueries to filter SELECT statements. subqueries are always processed from the inside out. Example: 1SELECTcust_name, cust_contact2FROMCustomers3WHEREcust_idIN (SELECTcust_idorder_numIN (SELECTorder_num6FROM

Subquery is a query nested in other queries. 1. Use subqueries to filter SELECT statements. subqueries are always processed from the inside out. Example: 1 SELECT cust_name, cust_contact 2 FROM MERs 3 WHERE cust_id IN (SELECT cust_id order_num IN (SELECT order_num 6 FROM

Subquery is a query nested in other queries.

1. Filter Using subqueries

In SELECT statements, subqueries are always processed from the inside out. Example:

1 SELECT cust_name, cust_contact2 FROM Customers3 WHERE cust_id IN (SELECT cust_idorder_num IN (SELECT order_num6FROM OrderItems ));