RE: [ifxmaillist] Query syntax help - Select 1 from multiple rows

Posted in 2000

Peter Ai — Thu, 2 Mar 2000 15:53:27 +1300 — source: Informix-list mailing list archive (1991-1998)

You can use cursor to fetch the first record that meets your criteria and close it immediately. Peter Ai peter@quanta.co.nz 302 3760 Quanta Systems Limited On Thursday, March 02, 2000 1:12 PM, PN [SMTP:pnguyen@lightspeed.net] wrote: > I need help: > Table A: > Cust_no > > Table B: > Cust_no > Cust_name > > Table B can contain duplicated cust_no's, each with an alternate name for > the customer > How can I select ONLY 1 record from table B using a cust_no from table A ? > Any help is greatly appreciated. > Thanks > PN > >