Display Rows as Columns in Query Result

  • Thread starter Thread starter Charles Law
  • Start date Start date
C

Charles Law

I used to have a table with columns

ID
FieldA
FieldB
FieldC
....

The following query would put FieldA in column 2, FieldB in column 3, and so
on

SELECT ID, FieldA, FieldB, FieldC FROM MyTable

I have normalized the table into two tables, where the second table has a
row for each of FieldA, FieldB, FieldC, etc. and links to the first table,
so a simple query would produce

ID FieldColumn
1 FieldA
1 FieldB
2 FieldA
2 FieldB
2 FieldC
3 FieldB
....

Can anyone suggest a query on the two new tables that would produce the same
result as I had from the original one table?

TIA

Charles
 
Not too worry. I have just seen the post from Raj Patel that answers my
question.

Charles
 
Back
Top