SELECT *, RECNO() AS nRecNo ; FROM Orders ; INTO CURSOR OrdersRecno SELECT Customer_ID, MAX(nRecno) AS nRecNo ; FROM OrdersRecno ; GROUP BY 1 ; INTO CURSOR RecentOrders SELECT RecentOrders.Customer_ID, Order_No, Order_Date ; FROM OrdersRecno ; JOIN RecentOrders ; ON OrdersRecno.Customer_ID = RecentOrders.Customer_ID ; AND OrdersRecno.nRecno = RecentOrders.nRecno ; INTO CURSOR Result<snip>