Menu

#46 Parser fails when || occures in GROUP BY.

open
nobody
None
5
2005-05-19
2005-05-19
Anonymous
No

Example SQL:
SELECT
COUNT(A.KUNDENR||' '||A.KONTRAKTNR) Antall
,C.RESEPTID||' '||C.RESEPTNAMN Tariff
,SUM(D.VFBMENGDE) "Venta forbruk"
FROM
KUNDE.EKKONTRAKTHIST B
,KUNDE.EKRESEPT C
,KUNDE.EKKONTRAKT A
,FELLES.V_EFVENTAFORBRUK D
WHERE
(B.KONTRAKTNR = A.KONTRAKTNR)
AND (B.KUNDENR = A.KUNDENR)
AND (C.RESEPTNR = B.RESEPTNR)
AND A.MAALEPKTNR = D.MAALEPKTNR
AND D.TELLEVERKARTNR = 1
AND D.VFBTILDATO = TO_DATE('01.06.2073','DD.MM.
YYYY')
and (a.valstatus = 'A')
and (b.tarfradato < sysdate)
and (b.tartildato >sysdate)
GROUP BY
C.RESEPTID||' '||C.RESEPTNAMN
,a.valstatus
ORDER BY
C.RESEPTID||' '||C.RESEPTNAMN
,a.valstatus

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.