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