Join two tables with Dates between condition (exceptions are also there)

[mithunjacob]

I am trying to join two tables based on a date which lies between start date and end date. But there are multiple cases where the condition satisfies this 'in between dates' . In such cases, I need to take Max End date which I am facing challenges. Could you please help?

Key - Code_IM + time in between Start date and End date

[mithunjacob]

The latest one which is closer to 'Time'. And once again thank you for valuable time and help.

[mithunjacob]

Sorry, I mean closer but Time>START_DATE

[ali_hijazi]

Then from the final table take records where Time > Start date

[ali_hijazi]

but for this case TIM is always greater than START DATE (all records are like that)