when pulling data from multiple tables, you need to use a join query syntax to make sure you are returning the related rows.
see the following page details on creating join queries:
sql_join.asp
without knowing the structure of your tables i can only guess at the relationships.