Missing Logic for Last Review date

hi experts

from bellow query i'm not getting emp last hike date

SELECT T0.[empID], T0.[firstName],T0.[salary] ,T1.[remarks],

(SELECT max (T1.[Date] ) FROM OHEM T0 full JOIN HEM3 T1 ON T0.empID = T1.empID )

FROM OHEM T0 full JOIN HEM3 T1 ON T0.empID = T1.empID WHERE T0.[status] is null AND T0.[termReason] IS NULL

please help me

Thanks & Regards

Andakondaramudu