Re: how to make 2 rows into 1 row?

Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3D220445.51EF1447_at_exesolutions.com>...
> julio wrote:
>
> > We have 2 rows of data. They are for the same item but have different
data
> > and we want 1 row. Does Sajar know?
> >
> > Terminal rating1 rating2
> > 1234 23 34
> >
> > Terminal addr prior adv
> > 1243 54 67 39
> >
> > we want
> >
> > Terminal rating1 rating2 addr prior adv
> > 1243 23 34 54 67 39

I don't quite understand. These must be rows from 2 different tables since they have different fields. Therefore, why won't a simple join work?

Select t1.terminal, rating1, rating2, addr, prior, adv from t1, t2
where t1.terminal = t2.terminal

Am I missing something?

Jim Lyons                     |  Operating Systems Specialist
OTS                           |  512-471-7414
University of Texas at Austin |  fax: 471-2449
http://www.weblyons.com       |  jlyons@weblyons.com