应该属于 MSSQL的内基础容！惭愧啊我！
UPDATE table_name
SET colname = 'new value'
WHERE colname = 'old value'

select table1_name.*,table2_name.colname from table1,tables2 where tables.colname=table2_name.colname