>Hi Jayesh, have question again
>
>If my file is setting order to "COMPANY_NAME",
> do i need to set the order to "ORDER_NO" before run SQL ...WHILE ORDER_NO="12345"
>
>****************
>
>I want make temp. file name from sys(3) and come with a alias name = "T_ASS2"
>
>I have coding as below :
>
>
>III = SYS(3)+".DBF"
>
>SELECT * FROM order_items
>WHERE order_no == "12345"
>INTO TABLE &III
>
>
>***how to addin the alias name = "T_ASS2"
Immediately following your select statement
issue...
USE (III) ALIAS T_ASS2