>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?
If it's not broken, fix it until it is.
My Blog