|
rafiki
Starting Member
1 Posts |
 Posted - 09/13/2012 : 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. |
|
Multi-table query
