RE: Query syntax help - Select 1 from multiple rows

Posted in 2000

shahid.mehmood@aku.edu — Thu, 2 Mar 2000 09:09:29 +0500 — source: Informix-list mailing list archive (1991-1998)

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BF83FD.1B6E56A6 Content-Type: text/plain Further info required. Do you need FIRST record, LAST record or any other one ??? Shahid Mehmood Software Designer II Information Systems Department The Aga Khan University Karachi Official:Y > -----Original Message----- > From: PN [SMTP:pnguyen@lightspeed.net] > Sent: Thursday, March 02, 2000 05:12 > To: informix-list@iiug.org > Subject: Query syntax help - Select 1 from multiple rows > > 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 > > ------_=_NextPart_001_01BF83FD.1B6E56A6 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: Query syntax help - Select 1 from multiple rows</TITLE> </HEAD> <BODY> Further info = required. Do you need FIRST record, LAST record or any other one = ??? Shahid Mehmood Software Designer II Information Systems = Department The Aga Khan = University Karachi Official:Y <UL> -----Original Message----- From:   PN [SMTP:pnguyen@lightspeed.net] Sent:   Thursday, March 02, 2000 05:12 To:     informix-list@iiug.org Subject:       = Query syntax help - Select 1 from = multiple rows 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 </UL> </BODY> </HTML> ------_=_NextPart_001_01BF83FD.1B6E56A6--