I'm wanting to do the following:

1.  Select custom profile fields (defined in the DNN database with which to set up users) to a dropdown or listbox control.  

2.  I'd like to present the values in the dropdown or listbox so that the selection is querying the userprofile/profilepropertydefintion tables for the profile data values and profile field descriptions, respectively, to present a single instance of a value. An example of the raw SQL for the selection would be: 

SELECT DISTINCT UserProfile.PropertyValue from ProfilePropertyDefinition inner join UserProfile ON ProfilePropertyDefinition.PropertyDefinitionID = UserProfile.PropertyDefinitionID Where PropertyName = 'specialty' 

3.  Based upon the selection, I'd like to provide a data grid of all users who meet the criteria select.

Is this doable in XMod?  I downloaded the evaluation version and have searched through some of the available documentation, but I don't see a way to join data tables for databinding to controls or otherwise filter with a DISTINCT option.