i think he wants the entire record, not just the one field.

Code
SELECT *
FROM ubbt_USERS u, ubbt_USER_PROFILE up
WHERE u.USER_ID = up.USER_ID
ORDER BY u.USER_DISPLAY_NAME

would get USERS and USER_PROFILE tables, which could be MOST of what you want..

2c