What needs correcting in the statement below to make it a valid UPDATE statement?
UPDATE titles
SET t.ytd_sales = t.ytd_sales + s.qty
FROM titles t, sales s
WHERE t.title_id = s.title_id
AND s.ord_date = (SELECT MAX(sales.ord_date) FROM sales)
That was the correct answer, well done!
Sorry, that was the wrong answer