摘要:
Update中使用表别名select中的表别名:select * from TableA as taupdate中的表别名:update taset ta.key = 1from TableA as ta如何用表中一列值替换另一列的所有值不同表列替换:update taset ta.key1 = tb.key2from TableA as ta, TableB as tbwhere ta.key = tb.key同一表列替换:update taset ta.key1 = tb.key2from TableA as ta, TableA as tbwhere ta.key = tb.key 阅读全文