mysql - SQL Update with joins not working what am i missing here? -

mysql - SQL Update with joins not working what am i missing here? -

i don't know why keeps returning:

#1064 - have error in sql syntax; check manual corresponds mysql server version right syntax utilize near 'from vendas left bring together clientes c on c.id = vendas.idcliente , c.idrespons' @ line 2

mysql query:

update vendas vendas left bring together clientes c on c.id = vendas.idcliente , c.idresponsavel not null left bring together funcionarios f on f.id = c.idresponsavel set vendas.idvendedorresponsavel = f.id vendas.idvendedoratendente null

try this

update vendas v left bring together clientes c on c.id = v.idcliente , c.idresponsavel not null left bring together funcionarios f on f.id = c.idresponsavel set v.idvendedorresponsavel = f.id v.idvendedoratendente null

mysql