Description
To search Model types for which ever client
Query :
To search Model types for which ever client
Query :
select SceneProcessStatus,Client,S.IRModelTypeId,M.ModelName,* from vwSceneTypeList S left join IRModelType M on S. IRModelTypeId=M.IRModelTypeId where S.SceneProcessStatus=1 and S.IsDeleted=0 and S.ClientId=160 and m.ModelName='Beverage' --------------------------------------------------