SQL aanpassen GEEN IDEE..

[barendrecht82]

Hieronder heb ik een SQL overzicht waar ik het volgende moet aanpassen, alleen hij werkt dan niet.


grtbk.reknr BETWEEN ' 81001' AND ' 91001' OR ' 271800' AND ' 271800' AND gbkmut.TransSubType <> 'X'


Ik wil namelijk een range hebben van de eerste grootboekrekeningen en ik wil de grootboekrek 271800 ook zien...

Hij rekent niet.. Wat doe ik fout





SELECT de.debcode AS debnr,de.cmp_name AS debname,grtbk.reknr AS reknr,grtbk.oms25_0 AS GlOms, (CASE
WHEN gbkmut.datum BETWEEN {d '2015-01-01'} AND {d '2015-01-31'} THEN ' 1'
WHEN gbkmut.datum BETWEEN {d '2015-02-01'} AND {d '2015-02-28'} THEN ' 2'
WHEN gbkmut.datum BETWEEN {d '2015-03-01'} AND {d '2015-03-31'} THEN ' 3'
WHEN gbkmut.datum BETWEEN {d '2015-04-01'} AND {d '2015-04-30'} THEN ' 4'
WHEN gbkmut.datum BETWEEN {d '2015-05-01'} AND {d '2015-05-31'} THEN ' 5'
WHEN gbkmut.datum BETWEEN {d '2015-06-01'} AND {d '2015-06-30'} THEN ' 6'
WHEN gbkmut.datum BETWEEN {d '2015-07-01'} AND {d '2015-07-31'} THEN ' 7'
WHEN gbkmut.datum BETWEEN {d '2015-08-01'} AND {d '2015-08-31'} THEN ' 8'
WHEN gbkmut.datum BETWEEN {d '2015-09-01'} AND {d '2015-09-30'} THEN ' 9'
WHEN gbkmut.datum BETWEEN {d '2015-10-01'} AND {d '2015-10-31'} THEN ' 10'
WHEN gbkmut.datum BETWEEN {d '2015-11-01'} AND {d '2015-11-30'} THEN ' 11'
WHEN gbkmut.datum BETWEEN {d '2015-12-01'} AND {d '2015-12-31'} THEN ' 12'
END) AS Periode,de.ClassificationID AS debclassID,cld.description AS cldOms
, SUM(CASE WHEN transtype IN ('N','C','P','F') THEN CASE WHEN TransSubType NOT IN ('R','S') THEN CASE WHEN bdr_hfl >= 0 THEN (bdr_hfl) ELSE 0 END ELSE CASE WHEN bdr_hfl < 0 THEN (bdr_hfl) ELSE 0 END END ELSE 0 END) AS Debit,

SUM(CASE WHEN gbkmut.valcode <> 'EUR' THEN CASE WHEN transtype IN ('N','C','P','F') THEN CASE WHEN TransSubType NOT IN ('R','S') THEN CASE WHEN bdr_val >= 0 THEN (bdr_val) ELSE 0 END ELSE CASE WHEN bdr_val < 0 THEN (bdr_val) ELSE 0 END END ELSE 0 END ELSE 0 END) AS DebitFC,
SUM(CASE WHEN transtype IN ('N','C','P','F') THEN CASE WHEN TransSubType NOT IN ('R','S') THEN CASE WHEN bdr_hfl >= 0 THEN 0 ELSE -(bdr_hfl) END ELSE CASE WHEN bdr_hfl < 0 THEN 0 ELSE -(bdr_hfl) END END ELSE 0 END) AS Credit,
SUM(CASE WHEN gbkmut.valcode <> 'EUR' THEN CASE WHEN transtype IN ('N','C','P','F') THEN CASE WHEN TransSubType NOT IN ('R','S') THEN CASE WHEN bdr_val >= 0 THEN 0 ELSE -(bdr_val) END ELSE CASE WHEN bdr_val < 0 THEN 0 ELSE -(bdr_val) END END ELSE 0 END ELSE 0 END) AS CreditFC,
SUM(CASE WHEN transtype IN ('N','C','P','F') THEN gbkmut.aantal ELSE 0 END) AS Aantal,
0 AS Budget,
0 AS BudgetQuantity,
0 AS TotalProd FROM gbkmut INNER JOIN grtbk ON gbkmut.reknr = grtbk.reknr
LEFT OUTER JOIN cicmpy de ON gbkmut.debnr = de.debnr
LEFT OUTER JOIN classifications cld ON de.classificationID = cld.classificationID
WHERE transtype IN ('N', 'C', 'P', 'F') AND remindercount <= 23 AND gbkmut.datum BETWEEN {d '2015-01-01'} AND {ts '2015-12-31 23:59:59'} AND grtbk.reknr BETWEEN ' 801001' AND ' 877000' OR ' 171800' AND ' 171800' AND gbkmut.TransSubType <> 'X' GROUP BY de.debcode,de.cmp_name,grtbk.reknr,grtbk.oms25_0, (CASE
WHEN gbkmut.datum BETWEEN {d '2015-01-01'} AND {d '2015-01-31'} THEN ' 1'
WHEN gbkmut.datum BETWEEN {d '2015-02-01'} AND {d '2015-02-28'} THEN ' 2'
WHEN gbkmut.datum BETWEEN {d '2015-03-01'} AND {d '2015-03-31'} THEN ' 3'
WHEN gbkmut.datum BETWEEN {d '2015-04-01'} AND {d '2015-04-30'} THEN ' 4'
WHEN gbkmut.datum BETWEEN {d '2015-05-01'} AND {d '2015-05-31'} THEN ' 5'
WHEN gbkmut.datum BETWEEN {d '2015-06-01'} AND {d '2015-06-30'} THEN ' 6'
WHEN gbkmut.datum BETWEEN {d '2015-07-01'} AND {d '2015-07-31'} THEN ' 7'
WHEN gbkmut.datum BETWEEN {d '2015-08-01'} AND {d '2015-08-31'} THEN ' 8'
WHEN gbkmut.datum BETWEEN {d '2015-09-01'} AND {d '2015-09-30'} THEN ' 9'
WHEN gbkmut.datum BETWEEN {d '2015-10-01'} AND {d '2015-10-31'} THEN ' 10'
WHEN gbkmut.datum BETWEEN {d '2015-11-01'} AND {d '2015-11-30'} THEN ' 11'
WHEN gbkmut.datum BETWEEN {d '2015-12-01'} AND {d '2015-12-31'} THEN ' 12'
END) ,de.ClassificationID,cld.description ORDER BY (CASE
WHEN gbkmut.datum BETWEEN {d '2015-01-01'} AND {d '2015-01-31'} THEN ' 1'
WHEN gbkmut.datum BETWEEN {d '2015-02-01'} AND {d '2015-02-28'} THEN ' 2'
WHEN gbkmut.datum BETWEEN {d '2015-03-01'} AND {d '2015-03-31'} THEN ' 3'
WHEN gbkmut.datum BETWEEN {d '2015-04-01'} AND {d '2015-04-30'} THEN ' 4'
WHEN gbkmut.datum BETWEEN {d '2015-05-01'} AND {d '2015-05-31'} THEN ' 5'
WHEN gbkmut.datum BETWEEN {d '2015-06-01'} AND {d '2015-06-30'} THEN ' 6'
WHEN gbkmut.datum BETWEEN {d '2015-07-01'} AND {d '2015-07-31'} THEN ' 7'
WHEN gbkmut.datum BETWEEN {d '2015-08-01'} AND {d '2015-08-31'} THEN ' 8'
WHEN gbkmut.datum BETWEEN {d '2015-09-01'} AND {d '2015-09-30'} THEN ' 9'
WHEN gbkmut.datum BETWEEN {d '2015-10-01'} AND {d '2015-10-31'} THEN ' 10'
WHEN gbkmut.datum BETWEEN {d '2015-11-01'} AND {d '2015-11-30'} THEN ' 11'
WHEN gbkmut.datum BETWEEN {d '2015-12-01'} AND {d '2015-12-31'} THEN ' 12'
END) ,de.ClassificationID,cld.description,de.debcode,de.cmp_name,grtbk.reknr,grtbk.oms25_0

 

[wampier]

between kan geen extra operators bevatten
[sql]
grtbk.reknr > ' 81001' AND grtbk.reknr <' 91001' OR grtbk.reknr =' 271800'
[/sql]

 

[barendrecht82]

Klasse bedankt hij werkt nu!