JOIN in SQL UPDATE statement

// under sql

MySQL

JOIN in SQL UPDATE statement, differences between MS SQL and MySQL MySQL:

UPDATE contact SET contact.company_fk = team.company_fk FROM contact
INNER JOIN team ON team.id = contact.team_fk

MS SQL:

UPDATE contact INNER JOIN team ON team.id = contact.team_fk SET
contact.company_fk = team.company_fk

Go Top