Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Addressed for Version 4.06 » View Incident Report |
Serious |
Reported By: Jose Eduardo Helminsky Reported On: 3/26/2004 For: Version 4.05 Build 1 |
It doesn't work: select dat, emp, num, pro, sum(qtd) as qtd, sum(qtd*pre) as tot from hive inner join hpev on (emp=hpev.emp and num=hpev.num and hpev.sit='Encerrado' and hpev.ope='Venda' and hive.dat >='2004-02-01' and hive.dat <='2004-02-28') group by emp,num,pro order by dat It works: select dat, emp, num, pro, sum(qtd) as qtd, sum(qtd*pre) as tot from hive inner join hpev on (emp=hpev.emp and num=hpev.num) where hpev.sit='Encerrado' and hpev.ope='Venda' and hive.dat >='2004-02-01' and hive.dat <='2004-02-28' group by emp,num,pro order by dat
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |