beck.patrick (9/24/2009)
So the (corrected) example code
update
a1
set
col = a2.col
from
table1 as a1,
table2 as a2
where
a1.col = a2.col
This will update table1.col to with the value of table2.col when they are already the same... the obvious conclusion is that the columns in the original question (coulmn, colum1, column and column2) are not typos! 😀
Actually, I've worked in places where that would be entirely believable! :w00t: