Hello,
Thanks a lot for information but I need something different from that.
I hope that somebody can help, I have written this :
SELECT PropertyValue
FROM UserProfile
WHERE
PropertyDefinitionID IN ('21','23','26','27','30','31','32')
and visibility=1
order by userid, propertydefinitionid
Here, I have all the informations that I need from each user but each part is on a different line and I need all the informations from the same user on one line. What can I do ?
I need that :
Nickname, name, adress,city,postal code, phone, mobile
and I have this :
Nickname |
Name |
adress |
city |
postal code |
phone |
mobile |
|
|
|
|
|
|
|
PLEASE Help me ... thanks a lot