correct way to update a table while using table alias in MS SQL is: ... I find it useful to turn an UPDATE into a SELECT to get the rows I want to ...
www.google.com.tw