Помогите переделать 4 запроса на 1 вложенный.
$result = mysql_query("SELECT p2jyb_jshopping_orders.order_date, p2jyb_jshopping_order_item.product_name, SUM( p2jyb_jshopping_order_item.product_quantity * p2jyb_jshopping_orders.order_subtotal ) AS q FROM p2jyb_jshopping_orders, p2jyb_jshopping_order_item
WHERE ( p2jyb_jshopping_orders.order_id = p2jyb_jshopping_order_item.order_id ) AND ( MONTH( p2jyb_jshopping_orders.order_date ) <=3 ) GROUP BY product_name ORDER BY product_name DESC ");
$result1 = mysql_query("SELECT p2jyb_jshopping_orders.order_date, p2jyb_jshopping_order_item.product_name, SUM( p2jyb_jshopping_order_item.product_quantity * p2jyb_jshopping_orders.order_subtotal ) AS q1 FROM p2jyb_jshopping_orders, p2jyb_jshopping_order_item
WHERE ( p2jyb_jshopping_orders.order_id = p2jyb_jshopping_order_item.order_id ) AND ( MONTH( p2jyb_jshopping_orders.order_date ) >3 ) AND ( MONTH( p2jyb_jshopping_orders.order_date ) <=6 ) GROUP BY product_name ORDER BY product_name DESC ");
$result2 = mysql_query("SELECT p2jyb_jshopping_orders.order_date, p2jyb_jshopping_order_item.product_name, SUM( p2jyb_jshopping_order_item.product_quantity * p2jyb_jshopping_orders.order_subtotal ) AS q2 FROM p2jyb_jshopping_orders, p2jyb_jshopping_order_item
WHERE ( p2jyb_jshopping_orders.order_id = p2jyb_jshopping_order_item.order_id ) AND ( MONTH( p2jyb_jshopping_orders.order_date ) >6 ) AND ( MONTH( p2jyb_jshopping_orders.order_date ) <=9 ) GROUP BY product_name ORDER BY product_name DESC ");
$result3 = mysql_query("SELECT p2jyb_jshopping_orders.order_date, p2jyb_jshopping_order_item.product_name, SUM( p2jyb_jshopping_order_item.product_quantity * p2jyb_jshopping_orders.order_subtotal ) AS q3 FROM p2jyb_jshopping_orders, p2jyb_jshopping_order_item
WHERE ( p2jyb_jshopping_orders.order_id = p2jyb_jshopping_order_item.order_id ) AND ( MONTH( p2jyb_jshopping_orders.order_date ) >9 ) AND (MONTH( p2jyb_jshopping_orders.order_date ) <=12) GROUP BY product_name ORDER BY product_name DESC ");

Запрос собирает данные для xyz анализа

javajdbc,

SELECT p2jyb_jshopping_orders.order_date, p2jyb_jshopping_order_item.product_name,
SUM( p2jyb_jshopping_order_item.product_quantity * p2jyb_jshopping_orders.order_subtotal ) AS q
FROM p2jyb_jshopping_orders, p2jyb_jshopping_order_item
WHERE ( p2jyb_jshopping_orders.order_id = p2jyb_jshopping_order_item.order_id )
AND ( MONTH( p2jyb_jshopping_orders.order_date ) <=3 )
GROUP BY product_name ORDER BY product_name DESC;
SELECT p2jyb_jshopping_orders.order_date, p2jyb_jshopping_order_item.product_name,
SUM( p2jyb_jshopping_order_item.product_quantity * p2jyb_jshopping_orders.order_subtotal ) AS q1
FROM p2jyb_jshopping_orders, p2jyb_jshopping_order_item
WHERE ( p2jyb_jshopping_orders.order_id = p2jyb_jshopping_order_item.order_id )
AND ( MONTH( p2jyb_jshopping_orders.order_date ) >3 )
AND ( MONTH( p2jyb_jshopping_orders.order_date ) <=6 )
GROUP BY product_name ORDER BY product_name DESC;
SELECT p2jyb_jshopping_orders.order_date, p2jyb_jshopping_order_item.product_name,
SUM( p2jyb_jshopping_order_item.product_quantity * p2jyb_jshopping_orders.order_subtotal ) AS q2
FROM p2jyb_jshopping_orders, p2jyb_jshopping_order_item
WHERE ( p2jyb_jshopping_orders.order_id = p2jyb_jshopping_order_item.order_id )
AND ( MONTH( p2jyb_jshopping_orders.order_date ) >6 )
AND ( MONTH( p2jyb_jshopping_orders.order_date ) <=9 )
GROUP BY product_name ORDER BY product_name DESC;
SELECT p2jyb_jshopping_orders.order_date, p2jyb_jshopping_order_item.product_name,
SUM( p2jyb_jshopping_order_item.product_quantity * p2jyb_jshopping_orders.order_subtotal ) AS q3
FROM p2jyb_jshopping_orders, p2jyb_jshopping_order_item
WHERE ( p2jyb_jshopping_orders.order_id = p2jyb_jshopping_order_item.order_id )
AND ( MONTH( p2jyb_jshopping_orders.order_date ) >9 )
AND (MONTH( p2jyb_jshopping_orders.order_date ) <=12)
GROUP BY product_name ORDER BY product_name DESC ;

tanglir,
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'soi.product_name ,SUM(case when MONTH( so.order_date ) <=3 then soi.product' at line 2

tanglir,
спасибо огромное!!! Разобралась!!!