{I+=codeWee;}
[SQL] Update table by using other table
UPDATE Table1
set Table1.USER_ID = B.MEM_ID
from  Table1 as A, Table2 as B
where (A.field1 = B.field1) 
HTML | PHP | C++ | DirectX11 | Javascript | C# | HTML5 | ASP | SQL | General | CSS | Oculus Rift | Unity3d | Virtools SDK | Tip | NSIS | PowerShell | node.js | Web API | RTSP | All
Copyright© 2016 CodeWee.com All rights reserved.