How do I write an update query to update a column in TabA with the information from other records in TabA?
Printable View
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