>Hi
>
>I have one temporary table ( TmpLinEnc ), with fields :
>RefArtigo
>QTD
>
>i have table ( LinEnc ) , with fields
>RefArtigo
>QTD
>
>Now , i want update table LinEnc , with TmpLinEnc
>
>
>Exemple TmpLinEnc
>RefArtigo -> Artigox
>QTD -> 6
>
>table LinEnc
>RefArtigo -> Artigox
>QTD -> 10
>
>I want in table LinEnc
>RefArtigo -> Artigo1
>QTD -> 4 && ( 10 table LinEnc - 6 table TmpLinEnc = 4 )
>
>
>I know make this with DO WHILE .NOT. Eof() ,
>but i like Know make that with one UPDATE SQL
>
>Do You undsertand , and can help me ?
>
>Thanks
select TmpLinEnc
scan
update LinEnc set QTD = QTD - TmpLinEnc.QTD ;
WHERE RefArtigo = TmpLinEnc.RefArtigo
endscan
Cetin