We're querying the 'userprofile' table and need to display the results for each user as one record.
What query do you use to display each user's data as one record?
Turn this:
ProfileID |
UserID |
PropertyDefinitionID |
PropertyValue |
PropertyText |
Visibility |
LastUpdatedDate |
18 |
5 |
40 |
John |
NULL |
2 |
09:22.4 |
19 |
5 |
42 |
Doe |
NULL |
2 |
09:22.4 |
20 |
5 |
48 |
United States |
NULL |
2 |
09:22.4 |
21 |
5 |
56 |
-360 |
NULL |
2 |
09:22.4 |
22 |
5 |
57 |
en-US |
NULL |
2 |
09:22.4 |
23 |
5 |
45 |
123 Main Street |
NULL |
2 |
11:30.7 |
24 |
5 |
46 |
Chicago |
NULL |
2 |
11:30.7 |
25 |
5 |
47 |
Illinois |
NULL |
2 |
11:30.7 |
26 |
5 |
49 |
60611 |
NULL |
2 |
11:30.8 |
27 |
5 |
50 |
555-5555 |
NULL |
2 |
11:30.8 |
28 |
5 |
51 |
444-4444 |
NULL |
2 |
11:30.8 |
29 |
5 |
52 |
333-3333 |
NULL |
2 |
11:30.8 |
Into this:
John |
Doe |
123 Main Street |
Chicago |
Illinois |
60611 |
United States |
555-5555 |
444-4444 |
333-3333 |
Thanks.