Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.03 » View Incident Report |
Serious |
Reported By: Krisztian Kepes Reported On: 5/6/2010 For: Version 2.03 Build 13 |
Wrong result: select cikk.cikkszam, sum(bizal.mennyiseg) as mozgas from cikk left outer join bizal on (bizal.cikk=cikk.kod) inner join bizfo on (bizfo.kod=bizal.kod) and (bizfo.datum >= DATE '2010-01-01') where cikk.raktar>0 and (cikk.Cikkszam BETWEEN '01' and '029999') group by cikk.cikkszam, cikk.kod, cikk.nev, cikk.ubear, cikk.raktar Correct result: select cikk.cikkszam, sum(bizal.mennyiseg) as mozgas from cikk left outer join bizal on bizal.cikk=cikk.kod and bizal.kod in (select kod from bizfo where bizfo.datum >= DATE '2010-01-01') where cikk.raktar>0 and (cikk.Cikkszam BETWEEN '01' AND '029999') group by cikk.cikkszam
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |