SELECT *, 000000000 AS rn ; >> FROM test ; >> WHERE Status = "1" ; >> AND ItemNum IN ( ; >> SELECT DIST ItemNum FROM s3) ; >> ORDER BY ItemNum, Cust, Sku ; >> INTO CURSOR s1 READWRITE >>