Example of how to build a join that makes use of a case
SELECT c.name ,t.name FROM SYS.COLUMNS c INNER JOIN SYS.TABLES t ON CASE WHEN c.object_id IS NOT NULL THEN c.object_id ELSE NULL END = t.object_id