Biology Forums - Study Force

Which of the following SQL statements is a correctly stated correlated subquery?

• SELECT C1.CustName, C1.SalesRepNo
FROM CUSTOMER C1
WHERE C1.SalesRepNo IN

(SELECT S1.SalesRepNo

FROM SALESREP S1

WHERE S1.RepName = 'Smith');

• SELECT C1.CustName, C1.SalesRepNo
FROM CUSTOMER C1
WHERE C1.SalesRepNo IN
(SELECT S1.SaleRepNo
FROM SALESREP S1
WHERE S1.RepName = 'Smith')
AND C1.SalesRepNo=S1.SalesRepNo);

• SELECT C1.CustName, C1.SalesRepNo
FROM CUSTOMER C1
WHERE C1.SalesRepNo IN

(SELECT S1.SaleRepNo

FROM SALESREP S1
WHERE S1.RepName = 'Smith')
AND C1.SalesRepNoS1.SalesRepNo);

• SELECT C1.CustName, C1.SalesRepNo
FROM CUSTOMER C1
WHERE C1.SalesRepNo IN
(SELECT C2.SaleRepNo
FROM CUSTOMER C2
WHERE C1.SalesRepNo=C2.SalesRepNo);
AND C1.OrderNoC2.OrderNo);

Content hidden

Thank you for answering so quickly