James,
In multitable selects functions like recno() even with an alias aregument are not going to work all the time. Just make your result set the primary key field.
>But if I use
>
> SELECT RECNO() FROM customer, order ;
> WHERE customer.custid = "001" .AND. ;
> order.orderid < "999"
><\PRE>