Chapter 7, Problem 122C

Program Plan Intro

Subquery:

A query which is nested inside a SELECT, INSERT, DELETE, UPDATE statement is called as subquery. A subquery is mostly embedded within a WHERE clause. It is possible to get values from multiple tables with the help of subquery.

IN Operator:

In SQL, “IN” operator is used to select values from the table which is equal to any of the values from the mentioned table.

Syntax:

SELECT * FROM table_Name WHERE condition1 IN value;