Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
transpose column to riows
- Thread starter vgeng
- Start date
dinger2121
Programmer
could you be a little more specific.
If they are like datatypes, you could look at using a union query.
If they are like datatypes, you could look at using a union query.
I have a feeling you've left crucial information out, but the following should do exactly what you are asking for
I suspect your root problem is an unormalized table structure, as what you are asking for implies that the field names contain data.
Code:
SELECT A, B As Whatever FROM TheTable
UNION
SELECT A, C As Whatever FROM TheTableI suspect your root problem is an unormalized table structure, as what you are asking for implies that the field names contain data.
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question