Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 11 to 15 of 15 total |
SQL Please help |
Fri, Jul 11 2008 2:06 AM | Permanent Link |
Dieter Nagy | Tim,
I changed the SQL to: Select zahl,count(total.zahl) <======== AS Anzahl, max(runde)AS Letzte_Runde,max(runde) -(select max(runde) from ZAHLEN) AS Differenz FROM zahl left join total on zahl.zahl = total.zahl group by zahl; and it works as expected. I get 0. I don't now why, but it is. Thanks for your help. Dieter "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote: Dieter, << I sent it to the binaries. At this time I tried it once again, but I can't. I send it now to <timyoung@elevatesoft.com>. >> Hmm, using your data and 2.00, I get the correct results also - a NULL for the third row/second column value. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Jul 11 2008 12:28 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Dieter,
<< and it works as expected. I get 0. >> What version of EDB are you using ? As I said, 2.00 B2 does not exhibit any issues with the original version of the query. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Jul 11 2008 1:30 PM | Permanent Link |
Dieter Nagy | Tim,
2.00 B2....... Dieter "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote: Dieter, << and it works as expected. I get 0. >> What version of EDB are you using ? As I said, 2.00 B2 does not exhibit any issues with the original version of the query. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Jul 11 2008 6:23 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Dieter,
<< 2.00 B2....... >> I don't see how this can be, but perhaps you could do me a favor and try 2.01 (just released) and see what the results are with it ? I'm definitely not seeing any issue with the query results here, the same as John. -- Tim Young Elevate Software www.elevatesoft.com |
Sat, Jul 12 2008 5:10 AM | Permanent Link |
Dieter Nagy | Tim,
tested with 2.01 the same. I use DBISAM also. Now as I now how I can handle this, is ist not a great problem. Thanks Dieter "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote: Dieter, << 2.00 B2....... >> I don't see how this can be, but perhaps you could do me a favor and try 2.01 (just released) and see what the results are with it ? I'm definitely not seeing any issue with the query results here, the same as John. -- Tim Young Elevate Software www.elevatesoft.com |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |