Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Corobori
Posting Yak Master
105 Posts |
 Posted - 2003-09-05 : 10:48:40
|
| This statement is from the SQL Server 2000 online book:UPDATE titlesSET t.ytd_sales = t.ytd_sales + s.qtyFROM titles t, sales sWHERE t.title_id = s.title_idAND s.ord_date = (SELECT MAX(sales.ord_date) FROM sales)I was wondering if the same sort of FROM clause is available in SQL Server CE ?jean-luc |
|
|
|
|
|
Update in SQL Server CE