DELETE
from VCLib.T_BASE_FEATURE_SETTINGS tbfs
using 
VCLib.T_CLIENT_MODULE_FEATURE tcmf,
VCLib.T_CLIENT_MODULES tcm
where tcmf.ClientModuleFeatureID = tbfs.ClientModuleFeature 
and tcmf.ClientModules = tcm.ClientModuleID
and tcm.ModuleType = 'SmoClientModule'
and tcmf.Name = 'HideVmpReferral';

delete
from VCLib.T_CLIENT_MODULE_FEATURE tcmf
using 
VCLib.T_CLIENT_MODULES tcm
where tcmf.ClientModules = tcm.ClientModuleID
and tcm.ModuleType = 'SmoClientModule'
and tcmf.Name = 'HideVmpReferral';