roberto
5/7/2018 - 3:46 PM

JOIN making use of CASE

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