SQLite manager query

I want to update column of one table from another table

UPDATE tbl_relations SET tbl_relations.WANTED = table_wanted.WANTED FROM table_wanted , tbl_relations  WHERE table_wanted.M_V_NO = tbl_relations.M_V_NO

And Error message in SQLite manager is

near ".": syntax error: