OCP-047 USING ORA-25154: USING 子句的列部分不能有限定词

最新推荐文章于 2022-09-21 12:12:58 发布

xiadingling

最新推荐文章于 2022-09-21 12:12:58 发布

阅读量3.4k

点赞数

分类专栏： OCP 文章标签： join date structure table sql

本文链接：https://blog.csdn.net/xiadingling/article/details/7859163

版权

当尝试使用JOIN子句结合USING(order_id)从orders和order_items表中选择数据时，会遇到ORA-25154错误，提示USING子句的列部分不能有限定词。尝试的不同SELECT语句都导致了相同的错误，即使在SELECT列表中省略表别名或完全省略别名。

摘要由CSDN通过智能技术生成

34. View the Exhibit and examine the structure of the ORDERS and ORDER_ITEMS
tables. Evaluate the following SQL statement:
SELECT oi.order_id, product_id, 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.
Answer: D

SQL> SELECT oi.order_id, o.product_id, order_date
2 FROM orders oi JOIN order_items o