Ok, this is more of a SQL question than a DNN question but it is dealing with the DNN tables.  Here is what I am trying to do:  I want to list a profile attribute of multiple users who are assigned to a specific role.  I have no problem selecting the attribute when there is only one user in that role, but obviously that won't do because there will be multiple users.

Here is my proposed SQL:

SELECT * FROM UserProfile WHERE (UserID = (SELECT UserID FROM UserRoles WHERE (RoleID = (SELECT TOP (1) RoleID FROM Roles WHERE (RoleName = 'CommunityMembers'))))) AND (PropertyDefinitionID = '39')

This should get me a list of the Profile Attribute that has the PropertyDefinitionID of 39 and are in the CommunityMembers Role.  In my case this is the company name, so this should list the company names of all users in the CommunityMembers role.  However, this obviously will not work since it is not valid SQL because the subquery returns more than 1 UserID since there are more than 1 users in the CommunityMembers role.  So I guess my question is how can I select multiple values from the table based on multiple ID's that will change everytime a new user is added?

And maybe I am going about this all wrong?  Any input would be greatly appreciated as I am a newb to SQL and DNN.

Wow, awesome.  Thanks much!  Told ya I was a newb! :D