Query against external database and roles in Drupal database

Hi

Been struggling with this for a while, so I thought I'd ask you if it's possible.

I have a database with a field, "project_name", where project_name will always have a Drupal user role with the same name. I'm trying to build a SQL statement that only prints information specific to the current_user where s/he has a Drupal role that matches a project_name. Something along the lines of:

--ACCESS=access content
select project_name, project_description from external_database
where project_name in (:users_groups)

Can such a thing be done?