>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.
>
What was that last sentance?

And it also sounds like instead of using code you would be better off setting up a DBC to hold these items as views.