Have you ever needed to update one table based on the contents of another table? The way to do it is with aliases.

view plain print about
1update t1 set t1.field=replace(t1.field, t2.field1, t2.field2) from table1 t1 inner join table2 t2 on t1.primaryKey=t2.foreignkey

This entry was posted on January 11, 2007 at 2:24 PM and has received 27527 views. There are currently 35 comments. Print this entry.