SELECT RECNO() FROM customer ;
         WHERE customer.custid = "001"

<\PRE>
to get a handy list of pointers to records in customer.dbf.

But if I use 


     SELECT RECNO() FROM customer, order ;
          WHERE customer.custid = "001" .AND. ;
                order.orderid < "999"
<\PRE>
it selects the RECNO() from order .dbf.

If I use 

     
     SELECT RECNO() FROM order, customer ;
         WHERE order.orderid < "999" .AND. ;
               custoemr.custid = "001"
<\PRE>
it still selects the order.dbf record number.

How do I tell a SQL SELECT statment which table I want to selct the RECNO() from?

Any ideas?

Regards,

Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.com

No trees were destroyed in sending this message.  However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.