What is your version? Why do you expect ppl to do your work for you?

>I am Using the following code to Update Subledger.DBF file from Journal.DBF.
>Kindly provide me Equivalent SQL to do the same. Currently I am using the following code.
>
>

>Select Subledger
>Go Top
>Scan While .Not. Eof()
>If Left(Vrno,2)=="J-"
>Alldata_Vrno=Vrno
>Select Journal
>Locate For Vrno==Alldata_Vrno
>If Found()=.T.
>SumNaration=Naration1+Naration2+Naration3+Naration4+Naration5
>Endif
>Select Subledger
>Replace Details With SumNaration
>Endif
>ENDSCAN
>

>
>Regards