Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  Multi-table query

Author  Topic  rafiki Starting Member 1 Post Posted - 2012-09-13 : 03:53:27 Hi. I'm working in MS Access 2007. I have tables A, B and C. A is a list of shops. B and C are two separate products, of which the shops in A sell either B or C or both. I have created a foreign key linking the shop identity in A to those shops in B or C selling products B or C. My question is: What is the SQL syntax for performing the queries that, conceptually, ask: "Which of the shops in A sell product B (or C)? Which of the shops in A sell both B and C?" Many thanks for your help. Apologies if this question is very elementary.