query

[dollygg]

Table A:

site phonetype number
1 phone 18001234567
1 fax 18661245789


Result wanted:


phoneNumber faxnumber
18001234567 18661245789

[Rawb]

Those Records have different site values.

Unless there is some other information linking the Records together somehow, you won't be able to do it.

[dollygg]

Actually the site number is same. I just fixed that.

[Rawb]

Probably the easiest is to use an INNER JOIN to connect two copies of your Table together.

SELECT TableA.[site], TableA.[number] AS PhoneNumber, TableA_1.[number] AS FaxNumber
FROM TableA INNER JOIN TableA AS TableA_1 ON TableA.[site] = TableA_1.[site]
WHERE TableA.[numbertype]="phone" AND TableA_1.[numbertype]="fax"