SELECT
k.id_Kunde,
k.LfNummer,
k.Kurzzeichen,
SUM(IF(b.BelegArt IN (3,5) THEN b.Summe ELSE -b.Summe)) as Gesamtumsatz

FROM kunden k

INNER JOIN (SELECT
             belegart,
             lfnummer,
             id_Beleg,
             id_Kunde,
             Summe,
             Datum
           FROM belege
           WHERE belegart IN (3,5,8)
             AND Datum BETWEEN :datumVON AND :datumBIS) b ON (b.id_Kunde = k.id_Kunde)

GROUP BY k.LfNummer
ORDER BY Gesamtumsatz DESC, k.Kurzzeichen

---

 Comments

---

This issue was caused by an unrelated fix (incident #3176) and only occurs when the derived table can return a sensitive (live) result set.

---

 Resolution

---

Fixed Problem on 4/20/2010 in version 2.03 build 12

---

 Products Affected

---

ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial