Querying a many to many relationship in access I have just created a many to many relationship in MS Access with three tables as shown below



AE Career Fair - Struc contains a list of companies where the company name is distinct.

Office Locations - Int is a junction table containing in one column all the companies occuring in AE Career Fair - Struc, but duplicated based on the countries in which they occur.  

Countries contains a list of all the countries in the world.

I was able to run a query for companies occuring in one particular country of interest. I would like to take this a step further and query this relationship and determine which companies are in more than one country. I cant really think of a way to do this based on how I currently have it set up. Could anyone provide indications as to how this would be done? Thanks.
I didn't really do a lot with MS Access, but you can try something like this, assuming that company.id is primary key and country.id is primary key and the corresponding tables are related to locations through company_id and country_id, respectively:

SELECT company.name, country.name
FROM locations
LEFT JOIN company 
ON company.id = locations.company_id
LEFT JOIN country 
ON country.id = locations.country_id
GROUP BY company.name 
HAVING count(locations.country_id) &gt; 1