SELECT type,desc,* FROM wipdata!logfile tl WHERE Date = (SELECT MAX(date) FROM logfile WHERE Jobno = tl.Jobno AND Type = tl.Type) into cursor tmptransSo to look up the employees/operators name from another table in SQL I would usually do something like this:
SELECT *,CNAME FROM wipdata!logfile,wipdata!operators where OPERATOR=NEMPNO into cursor tmptransHow do I insert the above into my code so far, as soon as I add wipdata!operators
SELECT * FROM TranLog tl >> WHERE Jobno = "..." AND >> TranDate = (SELECT MAX(TranDate) FROM TranLog WHERE Jobno = tl.Jobno AND TranType = tl.TranType)>>