How to get a Table name using Column name in SQL

SELECT  nameFROM sysobjects
WHERE id IN ( SELECT id FROM syscolumns WHERE name like '%Candidate%')