От: | pkarklin | ||
Дата: | 27.10.05 05:44 | ||
Оценка: | 2 (1) |
UPDATE titles
SET ytd_sales = titles.ytd_sales + sales.qty
FROM titles, sales
WHERE titles.title_id = sales.title_id
AND sales.ord_date = (SELECT MAX(sales.ord_date) FROM sales)