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

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

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

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

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