HuyPV
Tuesday, October 20, 2009
UPDATE Table1
SET Table1.Field1 = StagingTable.Field1
FROM Table1 INNER JOIN StagingTable ON Table1.Field2 = StagingTable.Field2
UPDATE ringtones_stats S INNER JOIN tmp_update_hit_count T ON S.ringtones_id=T.id
SET S.hit_count_week = T.hit_count
Title:
JOIN in SQL update statement
Description:
UPDATE Table1 SET Table1.Field1 = StagingTable.Field1 FROM Table1 INNER JOIN StagingTable ON Table1.Field2 = StagingTable.Field2 UPDATE ring...
...
Rating:
4