Ok Imagine this scenario... now I am just inheriting this and not the original architect.... And my apologies for being generic but to show real data would make it even...

Is there any way to put a case statement within a join like this

SELECT * FROM DESSERTS

CASE WHEN ____ = ____ then

JOIN someTable on...