I have three tables KUNDR, ORDRA, ARTIK.
I want to have sum of orders, grouped by costumers (KUNDR), and showing all costumers even if no orders that period.
My script here works, but its gave me all artikels (artik.grupp) if when I try to set criteria on artik
(select grupp, nr from artik where artik.grupp = 5)
How do I solve this so I can get all costumers every time even if I have critera on artik.grupp?
Thanks in advance /pellepels@gmail.com
Expand|Select|Wrap|Line Numbers
- SELECT KUNDR.NR AS Nr, SUM(ORDRA.TOT_LEV_ANTAL) AS Summa
- FROM KUNDR LEFT JOIN ORDRA ON KUNDR.NR = ORDRA.KUND_NR AND ORDRA.LEV_DATUM >= '2010-09-13' AND ORDRA.LEV_DATUM <= '2010-09-17'
- LEFT JOIN (select grupp, nr from artik where artik.grupp = 5) artikA ON artikA.NR = ORDRA.ART_NR
- WHERE KUNDR.NR IN(SELECT NR FROM KUNDR WHERE SPARR_KOD = 'N')
- GROUP BY KUNDR.NR