人生到处知何似，应似飞鸿踏雪泥： 泥上偶然留指爪，鸿飞那复计东西。 老僧已死成新塔，坏壁无由见旧题。 往日崎岖还记否，路长人困蹇驴嘶。

update kpi_goal a set unit = (select unit from kpi where kpi_id = a.kpi_id ) where a.unit is null;

-- 查找 app_id 与 ldap_org_code 的对应关系 SELECT a.app_id as app_id, a.app_datas->>'195' as org_name , sowpb.ldap_org_code as ldap_org_code from app a,soa_org_with_path_branch as sowpb WHERE a.str...