1. My "Order_items" file had over 500000 records. Now i want to make a temporary file, it's about the Order no. "12345" (there have 5 items only) I will coding as below : SELE ORDER_ITEMS SEEK ORDER_FILE->ORDER_NO COPY TO TEMP_FILE WHILE ORDER_NO == ORDER_FILE->ORDER_NO
USE TEMP_FILE IN 0 EXCL SELE TEMP_FILE Now i want to write in SQL ways, how to do ?? And i want to know, is't SQL must be faster then "SEEK + COPY TO (WHILE...)" 2. How to add more fields into existing file.