How to do join inside a case statement | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to do join inside a case statement

How to do join inside a case statement
Example
CASE WHEN @mSupCoun = ” THEN 1 ELSE CASE WHEN t.ClinNo IN (SELECT ClinNo FROM tblClient WHERE SupCounNo = @mSupCoun) THEN 1 ELSE 0 END END = 1
How can I replace clinno in the above with the join on clinno instead?
Thanks

I don’t understand the question… Are you able to post the complete query plus what you think the query should look like (even if the syntax is invalid…)? Twan
]]>