Posted by diablo on 11/16/05 15:02
>
> UPDATE product
> SET quantity = quantity - c.quantity
> FROM product p
> INNER JOIN Cart c
> ON p.productid=c.productid
Hi
This looked like what i wanted but it gives an error
"missing operator" FROM...
Thank
Kal
[Back to original message]
|