>
> SELECT RECNO() FROM customer, order ;
> WHERE customer.custid = "001" .AND. ;
> order.orderid < "999"

You can use local aliases.
SELECT RECNO("Cust") AS CustRecNO, RECNO("Ord") AS OrdRecNo ;
FROM customer Cust, order Ord;
WHERE Cust.custid = "001" AND ;
Ord.orderid < "999"
Does that work for you?