select distinct ownerId, ownerType from tbl_CRM_NoSaleReasons with (nolock) where ownerId > 0 -- and generalReason is null union select distinct ownerId, ownerType from tbl_CRM_SaleReasons with (nolock) where ownerId > 0 -- and generalReason is null

#htmleditformat( ownerType )#:#ownerId#