| skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResManagePersonMapper.xml | ●●●●● patch | view | raw | blame | history |
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResManagePersonMapper.xml
@@ -102,7 +102,7 @@ from "SJZT_MD"."att_res_manage_person" tmp where tmp."user_phone" = a."user_phone")) as role_id from (select * from (select distinct a."user_name", a."user_phone", concat(b."ad_guid", '000000') as "ad_code" from (select distinct a."user_name", a."user_phone", b."interior_ad_guid" as "ad_code" from "SJZT_MD"."att_res_manage_person" a left join "SJZT_MD"."att_res_base" b on a."res_guid" = b."guid" where "user_phone" is not null
