Driving me cookoo!!!

[disgruntled]

I have actaully asked this before but go no reply so i'll try my luck again. I need to retrieve a recordset from a table. The records i need to retrieve are related to another rs i've gathered which holds a list of keys. So me question is how do i write a query in SQL that takes 2 tables and returns the entries from the one only when the key is present in the other.

I am a newbie and lousy with the query builder if that is even poss. I have been writing all my queries in code thus far.

Help...I am at this road block all over my project.

Thanks a million.