SQL> select oi.order_id,product_id,order_date from order_items oi join orders o using(order_id) where rownum<=3;

select oi.order_id,product_id,order_date from order_items oi join orders o using(order_id) where rownum<=3

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

SQL> select order_id,product_id,order_date from order_items oi join orders o using(oi.order_id) where rownum<=3;

select order_id,product_id,order_date from order_items oi join orders o using(oi.order_id) where rownum<=3

ORA-01748: 此处只允许简单的列名

SQL> select order_id,product_id,order_date from order_items oi join orders o using(order_id) where rownum<=3;

ORDER_ID PRODUCT_ID ORDER_DATE

------------- ---------- --------------------------------------------------------------------------------

2458 3117 17-8月 -07 03.34.12.234359 上午

2458 3123 17-8月 -07 03.34.12.234359 上午

2458 3127 17-8月 -07 03.34.12.234359 上午