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
The column portion of the ora-25154:using clause cannot have a qualifier
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: Only simple column names are allowed here
Sql> Select order_id, product_id,order_date from Order_items oi join orders o using (order_id) where R ownum<=3;
order_id product_id Order_date
------------- ---------- --------------------------------------------------------------------------------
2458 3117 1 July-August-07 03.34.12.234359 am
2458 3123 1 July-August-07 03.34.12.234359 am
2458 3127 1 July-August-07 03.34.12.234359 am
ora-25154/ora-01748