160.View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables.

160.View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables.
There is only one customer with the cust_last_name column having value Roberts. Which INSERT
statement should be used to add a row into the ORDERS table for the customer whose

CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600?

A.INSERT INTO orders VALUES (1,'10-mar-2007', 'direct',
(SELECT customer_id FROM customers WHERE cust_last_name='Roberts' AND credit_limit=600), 1000);
B.INSERT INTO orders (order_id,order_date,order_mode,(SELECT customer_id
FROM customers WHERE cust_last_name='Roberts' AND credit_limit=600),order_total)
VALUES(1,'10-mar-2007', 'direct', &&customer_id, 1000);
C.INSERT INTO(SELECT o.order_id, o.order_date,o.order_mode,c.customer_id, o.order_total FROM orders o, customers c
WHERE o.customer_id = c.customer_id AND c.cust_last_name='Roberts' ANDc.credit_limit=600 ) VALUES (1,'10-mar-2007', 'direct',(SELECT customer_id
FROM customers WHERE cust_last_name='Roberts' AND credit_limit=600), 1000);
D.INSERT INTO orders (order_id,order_date,order_mode,(SELECT customer_id
FROM customers WHERE cust_last_name='Roberts' AND credit_limit=600),order_total)
VALUES(1,'10-mar-2007', 'direct', &customer_id, 1000);
答案：A
解析：BCD都是将select查询放入的需要插入的列的名称的位置了，肯定是错误的