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