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 val = qty * (select price from
historicalprice where historicalprice.itemid ==
salesrecord.itemid); {untested}
It depends on the version if you can use this.
>thanks.
>
>Radzi.
--
( Kees Nuyt
)
c[_]
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
