Difficulty understanding simple subqueries

Question

After noon,

I was asked to return some specific recordsets using subqueries, however, I find it difficult to understand how to use subqueries to get specific results.

Ex Using a subquery, list the product name from the product table for orderNumber 10121 from the orderdetails table.

I tried:

SELECT productName 
FROM products 
WHERE (SELECT orderNumber FROM orderdetails WHERE orderNumber = 10121); 

but apparently I missed something.

Any help would be appreciated.

Answer 1

. , , . , , , . , SQL :

SELECT productName FROM products WHERE productNumber IN (SELECT productNumber FROM orderdetails WHERE orderNumber = 10121);

, !