Thanks a lot, BB
This one:
SELECT Operator, Route, MAX(Start_Date) AS Start_Date;
FROM MyTable;
GROUP BY Operator, Route;
INTO CURSOR Tbl1
seems to work adequately for now.
Problems with my non-ETM SQL tyhough still - totally under-retrieving.
{gulp}
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.