What is a sub-select statement

A．a select statement that selects a subset of fields in a table

B．a select statement that returns a subset of the data in a table

C．a select statement that appears within another select statement

D．a select statement that returns a subset of the constraints on a field