SyntaxFix
Write A Post
Hire A Developer
Questions
Not able to understand your actual problem but your case statement is incorrect
CASE WHEN TABLE3.COL3 IS NULL THEN TABLE2.COL3 ELSE TABLE3.COL3 END AS COL4