[solved] – Question 76506

In the query below, what is the statement in between parenthesis?

SELECT CUSTOMERNAME
FROM CUSTOMER_T
WHERE CUSTOMERID IN
(SELECT DISTINCT CUSTOMERID FROM ORDER_T)

a list

A correlated subquery

A non-correlated subquery

A correlated insert statement

Expert Answer

---