sql - Mysql Update Query with three tables -

i'm try write sql statement based on jointure between 3 tables, , keep getting same error. here's code :

update l set name=n.title location l inner join location_instance on l.lid=i.lid inner join node n on n.nid = i.nid

there 3 tables in total : [location: (lid, name )] , [location_instance(nid,lid)] , [node(nid)].

sorry if question seems irrelevant you, still beginner in field. thanks

there no from clause in update

update location l inner join location_instance on l.lid=i.lid  inner join node n  on n.nid = i.nid set l.name=n.title