Hi
I 've do it with embeded a SELECT clause in the principal SELECT.
It looks like :
SELECT u.username,
(SELECT UID.data FROM prefix_user_info_field UIF, prefix_user_info_data UID WHERE UID.fieldid = UIF.id AND UIF.shortname = 'NumBadge' AND UID.userid = U.id) as "Badge",
(SELECT UID.data FROM prefix_user_info_field UIF, prefix_user_info_data UID WHERE UID.fieldid = UIF.id AND UIF.shortname = 'NumBadge' AND UID.userid = U.id) as "Badge",
u.lastname, ...
In this case, my profilefield is named 'NumBadge' and I write the content of the field in a colum named "Badge"
Hope this help you
Marcel