>Hi Sergey
>
>So if I use:
>
>

SELECT * FROM TranLog tl
>  WHERE Jobno = "..." AND
>      TranDate  =  (SELECT MAX(TranDate)  FROM TranLog WHERE Jobno = tl.Jobno AND TranType = tl.TranType)

>
>as a final requirement I want to fill in the employees name, field is NEMPNO I(4), AND CNAME C(20) is stored in
>OPERATORS & indexed on IEMPNO
>
>is this possible within the same SQL statement?
>
>

Sure, it's possible. Could you please post exact structures of the tables involved and the exact output you'd like to get?

How exactly the Operators table is related to LogFile?