On Mon, 16 Oct 2006 09:53:19 +0800, you wrote:
>update i set val=qty*q.price
>from salesrecord i
>inner join historicalprice q on i.itemid=q.itemid
I would use a correlated subquery which returns one column,
instead of the join. I don't think you can use aliasses there.
update salesrecord set
update i set val=qty*q.price
from salesrecord i
inner join historicalprice q on i.itemid=q.itemid
thanks.
Radzi.
* jayanth KP:
>Please can anybody respond to this question. I am able to hits is
>issue pretty often now...
You should check that your operating system and hardware actually
flush buffers when told to do so. Here's a test you can run:
*"Compilation Options For SQLite" page is too old: last modified on
2005/03/19 15:10:45* ,predefine as "SQLITE_OMIT_CHECK" and
"SQLITE_OMIT_VIRTUALTABLE" is not listed.
4 matches
Mail list logo