SQL - re-arrange a table via query
- by abelenky
I have a poorly designed table that I inherited.
It looks like:
User Field Value
-------------------
1 name Aaron
1 email [email protected]
1 phone 800-555-4545
2 name Mike
2 email [email protected]
2 phone 777-123-4567
(etc, etc)
I would love to extract this data via a query in the more sensible format:
User Name Email Phone
-------------------------------------------
1 Aaron [email protected] 800-555-4545
2 Mike [email protected] 777-123-4567
I'm a SQL novice, but have tried several queries with variations of Group By,
all without anything even close to success.
Is there a SQL technique to make this easy?