mysql update select 更改表数据

UPDATE news_catagory rs1 RIGHT JOIN ( SELECT tname, turl FROM lcTest ) rs2 ON rs1.`name` = rs2.tname SET rs1.path = rs2.turl where rs1.`name` in ( SELECT tname FROM lcTest )