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
>SELECT * FROM TranLog tl > WHERE Jobno = "..." AND > NOT EXISTS (SELECT 1 FROM TranLog WHERE Jobno = tl.Jobno AND TranType = tl.TranType and TranDate > tl.TranDate) > >-- or > >SELECT * FROM TranLog tl > WHERE Jobno = "..." AND > TranDate = (SELECT MAX(TranDate) FROM TranLog WHERE Jobno = tl.Jobno AND TranType = tl.TranType) > >>