Give this a try (included code to create sample data):

create table #TableTools (id int identity(1,1), name varchar(15), tools varchar(15))

insert into #TableTools values

('mike', 'walker')

,('mike', 'cane')

,('steve', 'walker')

,('mitchel', 'cane')

,('dave', 'cane')

,('mitchel', 'none')

-- actual query

SELECT NAME

FROM #TableTools

WHERE tools = 'walker' OR tools = 'cane' -- filter on two tools

GROUP BY NAME -- only return the distinct name

HAVING count(NAME) = 2 -- count needs to be 2 because we filter on two tools

drop table #TableTools