how to make 2 rows into 1 row?

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 Received on Tue Jul 02 2002 - 12:01:20 CDT