Possibly. An example.
SELECT *
FROM TableA
WHERE TableA.CustomerName IN
(SELECT FullName
FROM TableB
WHERE FullName Like 'Joh*'
GROUP BY FullName
HAVING Count(FullName) > 1)
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..