Skip to Content
0
Sep 17, 2014 at 10:37 AM

Missing Logic for Last Review date

17 Views

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