select x.variable::json->>'imageId'as imageId, x.status, y.image_name
from task x join image y on x.variable::json->>'imageId'= y.image_id
where x.variable::json->>'imageId'isnotnulland x.statusisnotnulland y.is_valid istrue;
postgresql多表联合批量更新
update table_p as p
set p_name = a.name,p_user = a.user_id,p_type ='P02'from(select x.user_id,x.name,x.p_id from table_u x
join table_p y on x.p_id = y.p_id
)as a where p.p_id = a.p_id;