|
|
Posted by Erland Sommarskog on 05/28/05 11:23
coosa (coosa76@gmail.com) writes:
> However, It gives me errors that category is ambigious
Correct. Change "UPDATE CATEGORY" to "UPDATE c". When a table appears
more than once in an UPDATE/DELETE statement you must use the alias
after DELETE, not the table name.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|