Assume that : Product table has ProductCode and Price Sales table has Qty, ProductCode (foreign key) and Total How do calculate the Total which Qty * Price

258.

Assume that :
Product table has ProductCode and Price
Sales table has Qty, ProductCode (foreign key) and Total

How do calculate the Total which Qty * Price

update Sales set Total=Qty * Product.Price
inner join Product on Sales.ProductCode=Product.ProductCode

update Sales set Total=Qty * Product.Price
from Sales inner join Product on Sales.ProductCode=Product.ProductCode

update Sales set Total=(select Qty * Price from Sales inner join Product on Sales.ProductCode=Product.ProductCode)

No description found.