SELECT * FROM uc_tenant_auth WHERE 1=1 AND TYPE_ID_=#{typeId,jdbcType=VARCHAR} AND TENANT_ID_=#{tenantId,jdbcType=VARCHAR} SELECT * FROM uc_tenant_auth WHERE USER_ID_=#{userId,jdbcType=VARCHAR} AND TYPE_ID_=#{typeId,jdbcType=VARCHAR} AND TENANT_ID_=#{tenantId,jdbcType=VARCHAR} SELECT DISTINCT auth.ID_,auth.TYPE_ID_,auth.TENANT_ID_,auth.USER_ID_,auth.USER_NAME_,auth.CREATE_TIME_, auth.CREATE_BY_,auth.CREATE_ORG_ID_,auth.UPDATE_TIME_,auth.UPDATE_BY_,u.ACCOUNT_,u.EMAIL_ FROM uc_tenant_auth auth LEFT JOIN uc_user u ON auth.USER_ID_ = u.ID_ ${ew.customSqlSegment} DELETE FROM uc_tenant_auth WHERE TYPE_ID_=#{typeId,jdbcType=VARCHAR} DELETE FROM uc_tenant_auth WHERE USER_ID_=#{userId,jdbcType=VARCHAR} DELETE FROM uc_tenant_auth WHERE TENANT_ID_=#{tenantId,jdbcType=VARCHAR}