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

Thanks, that works. The syntax i used is allowed in MS SQL. best regards, Radzi. - Original Message - From: "Kees Nuyt" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, October 16, 2006 1:54 PM Subject: Re: [sqlite] How do i do this UPDATE in SQL

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

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

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

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