>>Suhas
>>
>>Yoo don't need to sent the whole dbf - just the record structure (display struct) and a synopsis of what you want the SQL to achieve.
>>
>>Terry
>>
>
>hi terry,
>I am sending only a couple of months data I have taken off a years data. Total size would have been 14 MB above ziped. I want it to be fast thats why i have included a couple of months records.
>
>To which address should I send it to U?
>
>thanx
>
>suhashegde

Suhas

Like I said, sending your data to me would make no difference. I can see the table structures and what you want to do. You practically answered your own question, to wit:

>update bhav_data.delqty set delqty = del.delqty where bhav_data.symbol = del.symbol and
>bhav_data.series = del.series and bhav_data.date = del.date

update bhav_data ;
  set delqty = del.delqty ;
  where bhav_data.symbol = del.symbol ;
  and   bhav_data.series = del.series ;
  and   bhav_data.date = del.date

Does this do it?

Terry