以下SQL语句正确的有()。
以下SQL语句正确的有()。
A、SELECT cust_id FROM Orders WHERE order_num IN (SELECT cust_id FROM OrderItems WHERE prod_id ='RGAN01')
B、SELECT cust_id FROM Orders WHERE order_num IN (SELECT order_num FROM OrderItems WHERE prod_id ='RGAN01')
C、SELECT * FROM Orders WHERE cust_id IN (SELECT cust_id FROM OrderItems WHERE prod_id = 'RGAN01')
D、SELECT * FROM Orders WHERE cust_id IN (SELECT order_num FROM OrderItems WHERE prod_id ='RGAN01')