I am trying to determine if one or the other value exists in a subquery result set. For some reason I'm drawing a blank at being able to combine this
SELECT [ColA] = CASE
WHEN ('Multiple Suppliers' IN (
SELECT CompanyName
FROM tlkLookUp
WHERE [WP] = '40' )
OR
Col_CompanyName IN (
SELECT CompanyName
FROM tlkLookUpTable
WHERE [WP] = '40' )
)