|
Hello, I'm Haren. I want to update Opening_Stock from table ( Product_Master ) with sum of Quantity from Issue_detail table where Product_code from both tables are equal & Issue_date is less than some specified date
(comments are locked)
|
|
You need to use the UPDATE... SET ... FROM ... WHERE... method to define the query. The beginning is like any UPDATE statement but from there you deviate into the FROM clause. It only gets strange because you don't have to qualify columns from the original table. Thanks Fritchey I'll try & see
Jan 21 '12 at 03:38 AM
Haren
(comments are locked)
|
Your answer
