Advanced query

[Guest]

I have an customer database, with a table of customers, and an order table.

Each customer can order a variety of products. If the order a product with a
spesific product group, they are entitled to customer support for all the
products they have ordered.

I need a query that lists all customers that have ordered a product form
this product group, with all the items they have ordered (also from other
product groups). The query should ignore customers who have no order of
products from the speciific group.

How can this be done?

 

[John Spencer (MVP)]

Create a query that shows all the customers that have ordered the product and
save it as a named query (CustomersOrderingProduct)

Now build another query with that query and your other tables. Joining the
customerID from the query to the customerid in the customers table.