Posted on 2009-07-12
I need to set up a query and I'm not sure of the syntax. Here is the schema scenario:
A 'Company' table with companyID and companyName.
A 'Delivery Areas' table with areaID and areaDescription.
A CompanyDeliveryCrossReference table with a refID (just autonumber), companyID, and areaID
The cross reference table will have an entry for each area that the company delivers within. What would a query look like if it were looking for companys that delivered in all:Area1, Area2, Area3?