update a set value=1 where a.id in (select aid from b where b.id='2')
table b is apply for path_man