[sqlite] How do i do this UPDATE in SQLite?

[Mohd Radzi Ibrahim]

update i set val=qty*q.price
from salesrecord i
inner join historicalprice q on i.itemid=q.itemid


thanks.

Radzi.