Is the value of the second field (cRs.Partida) in the cursor cEl Null in the extra records? What is the type of Partida field?
>I can't figured out what happens. the first time it works. the second time I run it second query gives me ALL records from Partida!
>
>
>SELECT Results.Partida ;
> FROM Results ;
> GROUP BY Results.Partida ;
>INTO CURSOR cRS NOFILTER
>
>** 8 records as I expect
>
>SELECT Partida.Name, cRs.Partida;
> FROM cRs;
> LEFT JOIN Partida ON cRs.Partida == Partida.Kod;
> ORDER BY cRs.Partida;
> INTO CURSOR cEl
>
>** 110 records?
>
>BROW
>
>
>If I remove JOIN clause all is OK, But how is that it is LEFT join not RIGHT one.
--sb--