Hello Please help me with this question..

I have a Table PGW.CNTL.

It contains Empl_ID and PGW_CNTL_ID which is updated when ever a record is updated. I need the EMPL_ID of the most current record and match it with EMPL Table to get the names

This is what i have Made...


Select E.Last_NAME, E.FIRST_NAME
FROM PGW_CNTL AS PGC
INNER JOIN...