Take a look at inner joins.

Based on what you have written this should get you the information you require.