, . , OrdersWithOutOfStockltems, .
? , . Orders :
■ ID , ;
■ OnHoId .
, OnHold ( ). . , , ID, OrdersWithOutOfStockltems. ?
. -, In, , . In:
In (14,15,16)
14,15 16-
, ID . , OrdersWithOutOfStockltems.
: .
, . SQL, 6.
SELECT, , , FROM , . SQL , ID () OrdersWithOutOfStockltems:
SELECT OrderID FROM OrdersWithOutOfStockltems
, , . :
In (SELECT OrderID FROM OrdersWithOutOfStockltems)
ID. (ID) OrdersWithOutOfStockltems Orders. . 8.10.
. 8.10. (PutOutOfStockOrdersOnHold ( )) , Boutique Fudge . OnHold. ,
, , , . , , .
9