Re: how to make 2 rows into 1 row?

In article
<Pine.OSF.4.44.0207031228000.29184-100000_at_curly.cc.utexas.edu>,  Jim Lyons <jlyons_at_uts.cc.utexas.edu> wrote:

> 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?

Yes. The table structure.

-- 
The underscore character does not belong in my address. You know the drill...
***
Anyone sufficiently smart enough to configure and use USEnet for research should
be smart enough to Read The Freakin' Documentation!