Posts
33
Comments
186
Trackbacks
0
Tuesday, March 13, 2012
Update Query in SQL with SELECT statement
UPDATE 
   
Table 
SET 
   
Table.col1 = other_table.col1, 
   
Table.col2 = other_table.col2 
FROM 
   
Table 
INNER JOIN 
    other_table 
ON 
   
Table.id = other_table.id 
Posted On Tuesday, March 13, 2012 4:16 PM | Comments (2)