-
update syntax for same table update
How do I write an update query to update a column in TabA with the information from other records in TabA?
-
join the table with itself (self join) and update the columns you want with the rows you want.
look in books online for UPDATE, there are examples which can guide you.
-
Depends on what you really need.
update table1 set column1 = 'joe' where column2 = 'smoe'
You might post what you need to get more detailed help.
HTH
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|