Mysql update from

UPDATE

tab1   a INNER JOIN tab_game_version as b ON a.id=b.id

SET a.advert_data=0

where a.advert_data is NULL

sql server 

 update tab set  f =  1 from  xxxxxxxxx

xxxxxxxxxx 

where