How to use IF Else inner Join

Question

Hi..

How to use IF and Else Condition in Inner Join.