Hi,

Have you tried it with 'LinhaFac, TmpNCOri' in the FROM clause?

HTH,
Arriyel

>Hi
>
>I have the following select
>
>

>SELECT LinhaFac.* FROM LinhaFac ;
>  JOIN TmpNcOri ON LinhaFac.NumDoc = TmpNcOri.NumDoc;
>  WHERE TmpNcOri.Selecciona AND Upper(TmpNcOri.origem) = "FACTDOC";
>  INTO CURSOR TmpLinFacX
>

>
>don´t work , because TmpLinFacX is empty .
>
>But if i make :
>
>

>
>Select TmpNCOri
>BROWSE
>
>SELECT LinhaFac.* FROM LinhaFac ;
>  JOIN TmpNcOri ON LinhaFac.NumDoc = TmpNcOri.NumDoc;
>  WHERE TmpNcOri.Selecciona AND Upper(TmpNcOri.origem) = "FACTDOC";
>  INTO CURSOR TmpLinFacX
>

>
>Work Ok , TmpLinFacX have records .
>
>Why ? What i can do ?
>
>
>Thanks