When I execute the following query, I get the message like ORA-01427: single-row subquery returns more than one row

Viewed 47
select c.cust_id,
       c.company_name, 
       (select count(order_id) from orders 
        union 
        select count(order_id) from orderdetails)
from Orders o,
     Customer c,
     OrderDetails od;
0 Answers
Related