Update Table from Other Tables Values

Yes, you can update table from other table certain fields values. Of course you need at least one field related each other. Syntax please!! Here you go:

UPDATE Table SET Table.col1 = other_table.col1, Table.col2 = other_table.col2 
FROM Table INNER JOIN other_table ON Table.id = other_table.id