问题:
View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables. Evaluate the following SQL statement:
SELECT oi.order_id, product_jd, order_date
FROM order_items oi JOIN orders o
USING (order_id);
Which statement is true regarding the execution of this SQL statement?()
A . The statement would not execute because table aliases are not allowed in the JOIN clause.
B . The statement would not execute because the table alias prefix is not used in the USING clause.
C . The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.
D . The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.
View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables. Evaluate the following SQL statement:
SELECT oi.order_id, product_jd, order_date
FROM order_items oi JOIN orders o
USING (order_id);
Which statement is true regarding the execution of this SQL statement?()
● 参考解析
本题暂无解析