Using SQL Server 2008 R2.
I want join table a to table b on a.businessKey = b.TMonths.
When b.TMonths >= 120 then it should join to businesskey = '>120' on table a;
when b.TMonthsis null, then it should join to businesskey = '0' on table a;
In all other cases a.businessKey = b.TMonths
How to create this Join?