hello *.*

I need to select just the first record from a SELECT STATMENT, like this:

SELECT customer.OID, reserv.OID
     from customer, reserv
     where customer.OID = 1234
     into cursor test

Ok, this SELECT may return many records, but I want select just the first record. How can I do it ?

I´ve tried use the SAMPLE STATMENT, but We can´t use this statment with 2 tables or more.

Please, help me!

Thank you ALL