ID_, ORG_ID_, ORG_CODE_, ORG_NAME_, SHARING_ORG_ID_, SHARING_ORG_CODE_, SHARING_ORG_NAME_, SHARING_MENU_ALIAS_, REMARKS_, IS_DELE_, CREATE_BY_, CREATE_NAME_, CREATE_DEPT_ID_, CREATE_DEPT_NAME_, CREATE_ORG_ID_, CREATE_ORG_NAME_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_DEPT_ID_, UPDATE_DEPT_NAME_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_TIME_, LAST_TIME_, VERSION_, TENANT_ID_ select * from biz_data_sharing ${ew.customSqlSegment} SELECT b.SHARING_NOTICE_ID_ FROM biz_data_sharing a RIGHT JOIN biz_data_sharing_detail b ON a.ID_ = b.DATA_SHARING_ID_ WHERE a.IS_DELE_ = '0' AND a.SHARING_ORG_ID_ = #{orgId}