MySQL – 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 INNER JOIN tbl_B ON tbl_A.x = tbl_B.y SET tbl_A.w = tbl_B.z

MSSQL verzija: MSSQL: Update INNER JOIN

This entry was posted on Wednesday, February 12th, 2014 at 2:53 pmand is filed under MYSQL 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.