UBB.threads PHP Forum Software Community Forums Resources and Customizing How Do I? How Do I generate an email list of new registrant this month?

I guess I need this?

SELECT USER_REAL_EMAIL FROM ubbt_USER_PROFILE

but how do you tie it in with another table i.e. ubbt_USERS?

SELECT USER_DISPLAY_NAME
FROM ubbt_USERS
WHERE USER_REGISTERED_ON >= .....