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