>>>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.
>
>Can't. I'm working with FPD26 tables that are still used by the old system that I'm supposed to replace.
>
>Boris probably understands my last sentence as he was helping me with the SQL
>
>Cheers
you can creat a DBC that uses local views to the fpd tables