Re: how to make 2 rows into 1 row?

From: <catherinedevlin_at_removethispart.toast.net>
Date: 2 Jul 2002 18:35:49 GMT
Message-ID: <afsrq5$vke$1@news.netmar.com>

You mean... a join?

I assume that you meant Terminal was 1234 for both records...

SELECT t1.terminal,
       t1.rating1,
       t1.rating2,
       t2.addr,
       t2.prior,
       t2.adv
FROM   table1 t1,
       table2 t2

WHERE t1.terminal = t2.terminal

You can select it, make a view of it, make a table of it, whatever...

• Catherine Devlin http://profiles.yahoo.com/arcticturtle

In article <3d21dbcd$0$90827$45beb828_at_newscene.com>, julio <julio33_at_whomail.com> writes:
>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
>
>Julio and Colin and Lyse
>
>See my babies at
>
>http://www.geocities.com/colin_and_lyse/colin_lyse.html

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net

Received on Tue Jul 02 2002 - 13:35:49 CDT