Sounds like you could do this with a parameterized query (so a stored procedure) with a join between the two tables in question.