SELECT 38 ZAP alias38 = ALIAS() SELECT 6 alias6 = ALIAS() ******* UPDATE: SELECT DISTINCT scode, lcode, sec FROM &alias6 GROUP BY scode, lcode, sec INTO CURSOR cTest SELECT (alias38) APPEND FROM DBF("cTest") USE IN SELECT ("cTest")