pb clause select [Résolu]

[bb5477]

bonjour,
j'ai une requête a effectuer mais je ne parviens toujours pas à resoudre le problème...

mes tables:
sales_order(ORDER_ID ,ORDER_DATE,CUSTOMER_ID,TOTAL)
customer(CUSTOMER_ID,CREDIT_LIMIT)

voici ma requête:

Code :

1
2
3
4
5
6
7
8
 
SELECT DISTINCT c.name AS "name",
(SELECT s.total FROM sales_order s WHERE s.customer_id=c.customer_id AND to_char(s.order_date, 'Q')=1) AS "1st",
(SELECT s.total FROM sales_order s WHERE s.customer_id=c.customer_id AND to_char(s.order_date, 'Q')=2) AS "2nd",
(SELECT s.total FROM sales_order s WHERE s.customer_id=c.customer_id AND to_char(s.order_date, 'Q')=3) AS "3rd",
(SELECT s.total FROM sales_order s WHERE s.customer_id=c.customer_id AND to_char(s.order_date, 'Q')=4) AS "4th"
FROM customer c, sales_order s
WHERE c.customer_id=s.customer_id;

erreur:
ORA-01427: single-row subquery returns more than one row

[Garuda]

Code :

1
2
3
4
5
6
7
select distinct c.name as "name",
(select sum(s.total) from sales_order s where s.customer_id=c.customer_id and to_char(s.order_date, 'Q')=1 ) as "1st",
(select sum(s.total) from sales_order s where s.customer_id=c.customer_id and to_char(s.order_date, 'Q')=2) as "2nd",
...
from customer c, sales_order s
where c.customer_id=s.customer_id;