Re: Display only one value where there are more than one values for the first table

From: GD (NoSpam_g_du_at_comcast.net)
Date: 09/19/04 

Date: Sat, 18 Sep 2004 20:06:11 -0500

"nib" <nib@nibsworld.com> wrote in message
news:eH7be6dnEHA.132@TK2MSFTNGP09.phx.gbl...
> Display it in what?

Load it into a DataReader, then display it in a text box of a web
application using ADO.Net.

> GD wrote:
> > Hi,
> > Here is the query:
> > -------------------------------------------
> > select employees.LastName,orders.OrderID
> > from employees, orders
> > where employees.employeeID = orders.employeeID
> > ----------------------------------------------------
> >
> > It displays:
> > LastName OrderID
> > -----------------
> > Buchanan 10248
> > Buchanan 10254
> > Buchanan 10269
> > Callahan 10262
> > Callahan 10268
> > Callahan 10276
> > ------------------
> >
> > How can I display it like this:
> > LastName OrderID
> > -----------------
> > Buchanan
> > 10248
> > 10254
> > 10269
> > Callahan
> > 10262
> > 10268
> > 10276
> > ------------------
> >
> > Thanks.
> >
> > GD
> >
> >

Relevant Pages

  • Re: Records Duplicating after a Join
    ... >Orders (ORDERID, CODE, ORDERQTY) ... >STOCK. ... >How do I just display one location code for each record in the orders table? ...
    (microsoft.public.sqlserver.mseq)
  • Records Duplicating after a Join
    ... Orders (ORDERID, CODE, ORDERQTY) ... How do I just display one location code for each record in the orders table? ... I dont mind which location code it is - I just need to avoid having multiple ...
    (microsoft.public.sqlserver.mseq)
  • Re: Give user ability to copy last record?
    ... The problem is, if the OrderID is an autonumber, how do you determine the ... the form will display the first record in the ... ShipperID, CustPOnum, InvoiceNo, OrderDate, RequiredDate, ShippedDate, ... Set rsobj = CurrentDb.OpenRecordset'target table ...
    (microsoft.public.access.modulesdaovba)
  • Re: Give user ability to copy last record?
    ... The problem is, if the OrderID is an autonumber, how do you determine the ... to have the recordsource sorted on OrderID Descending. ... the form will display the first record in the ... Set rsobj = CurrentDb.OpenRecordset'target table ...
    (microsoft.public.access.modulesdaovba)
  • Re: xorg resolution on new laptop
    ... name of display::0.0 ... Subsection "Display" ... ViewPort 0 0 ... Load "extmod" ...
    (freebsd-questions)