JOIN 2 selects
Hej EksperterHvordan "JOINER" jeg to komplette selects ala følgende.
Ordre indgang - Grupperet efter uger
-------------------------------
SELECT YEAR(so.order_date) AS year, WEEK(so.order_date) AS week, SUM( si.line_total ) AS indgang
FROM sales_order_items AS si
LEFT JOIN sales_order AS so ON so.sales_order_id = si.sales_order_id
WHERE so.deleted !=1
AND so.order_date IS NOT NULL
AND so.deliverydate_wanted >= "2010-01-01"
AND so.deliverydate_wanted <= "2013-12-31"
GROUP BY YEARWEEK(so.order_date)
ORDER by year, week
LIMIT 0,200
Ordre udgang - Grupperet efter uger
-------------------------------
SELECT YEAR(so.delivery_date) AS year, WEEK(so.delivery_date) AS week, SUM( si.line_total ) AS udgang
FROM sales_order_items AS si
LEFT JOIN sales_order AS so ON so.sales_order_id = si.sales_order_id
WHERE so.deleted !=1
AND so.order_date IS NOT NULL
AND so.deliverydate_wanted >= "2010-01-01"
AND so.deliverydate_wanted <= "2013-12-31"
GROUP BY YEARWEEK(so.delivery_date)
ORDER by year, week
LIMIT 0,200
Det samlede output skulle gerne blive
year - week - indgang - udgang
