MSSQL: Update INNER JOIN

Problem: Updejtati polje X tablice A vrijednošću polja Y tablice B tamo gdje je podatak W tablice A jednak podatku Z tablice B

Rješenje:


UPDATE tbl_A

SET tbl_A.w = tbl_B.z

FROM tbl_A

INNER JOIN tbl_B ON tbl_A.x = tbl_B.y

 

MySQL verzija: MySQL – UPDATE INNER JOIN

 

This entry was posted on Sunday, March 15th, 2015 at 10:19 amand is filed under MSSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

Comments are closed.