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

From: Peter Ai <peter@quanta.co.nz> > >You can use cursor to fetch the first record that meets your criteria and >close it immediately. > >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 >? GROUP BY or SELECT FIRST? :-) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com