Help With Combining information in a Query

[aracosta]

Hello,

I have to query a table that stores customer information by a trans seq. There are three address types for each of these seqs. Would it be possible to write a query that combines the information.

The Current table set up is as follows;

Transseq, Address_Type, Company, State
1, Bill TO, NASA, CA,
1, ShipTO, DLT, MA,
1, Otherto, misc, PA,

I have had very little sucess trying to write a query that displays the information as follows;

Transseq, BILLTO_COMPANY, BILLTOSTATE, IPTOCOMPANY ,SHIPTOState
1, NASA, CA, DLT, MA,

Any ideas or suggestions would be greatly appreciated,
thank you,
-A

[Banfa]

Either, perform a simple query to get all the data using Transseq as the key then post process to extract Billing infomation and shipping information or perform 3 queries using Transseq and Address_Type as the keys or split your table into 3 tables different tables remove the Address_type so you can join them on Transseq.