Thanks, Sirdude!
Query #1 worked like a charm. With #2 I got this error:
Line#: 101
SQL Error: Unknown column 'u.USER.ID' in 'field list'
SQL Error #: 1054
I noticed that in #1 you used u.USER_ID so I gathered my courage (
) and substituted that for u.USER.ID in #2, like this:
SELECT u.USER_ID, u.USER_DISPLAY_NAME
FROM ubbt_USERS u,
ubbt_USER_PROFILE up
WHERE up.USER_ID=u.USER_ID
AND up.USER_SHOW_LEFT_MYSTUFF=1
Got believable results with that, so I guess I guessed right?