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?