Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Addressed for Version 3.05 » View Incident Report |
Serious |
Reported By: Gary Jones Reported On: 1/29/2002 For: Version 3.04 Build 1 |
Table structures: Table1 ------------------ Name String10 Number1 Integer Table2 ------------------ Name String10 Number2 Integer Table data: Table1 --------- Smith 3 Jones 4 Table2 --------- Smith 2 Jones 3 Result required: Jones 4 3 Smith 3 2 In DBSYS 3.03, the following SQL produces the correct results: select name,SUM(number1) As Tot1, SUM(0) As Tot2 from table1 union select name,0,number2 from table2 GROUP BY name A workaround that seems to work is to adapt the SQL slightly as follows: select name,SUM(number1) As Tot1, SUM(0) As Tot2 from table1 union select name,sum(0),sum(number2) from table2 GROUP BY name The same SQL in DBSYS 3.04 produces: Jones 4 493921239043 Smith 3 446676598786
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 |