In this sql statement I need to fix the If Then portion beginning in line 10. Please help.
Select e.*
From [plan] ep
Inner Join plandetail epd
On epd.planid = ep.id
And 200805 between pd.starting and pd.ending
Inner Join [plan] mp
On epd.managerplanid = mp.id
And 200805 between mp.starting and mp.ending
Inner Join Assignment a
If mp.ID = 36 Then
On a.planid In (36, 235)
Else
On a.planid = mp.id
End if
And 200805 <= a.ending
Inner Join Employee e
On e.id = a.employeeid
And 200805 between e.starting and e.ending
Where p.id = 35
Order By e.name
Start Free Trial
