PGSQL 跨表更新字段

select*from total_fault_milestone
 update total_fault_milestone set state='done' ---sql跨表更新
 UPDATE total_fault_milestone SET line=z.id FROM(SELECT * FROM line_line
) z WHERE z.name=total_fault_milestone.line_moved0 and total_fault_milestone.line is NULL