SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 Other Forums
 MS Access
 Multi-table query
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 09/13/2012 :  03:53:27  Show Profile  Reply with Quote

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.
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000