SELECT( ) example

It’s common practice to use SELECT( ) to open a table in the next available work area. This way, you don’t have to worry about accidentally closing an open table. You then always use the alias name to refer to that table. For example:

use CUSTOMER in select( ) order CUST_NAME

use ORDERS in select( ) order CUST_ORD

use LINEITEM in select( ) order ORD_LINE

select CUSTOMER