multi table join question
Posted by: Kyle Davis
Date: February 12, 2007 11:57AM

I have 3 tables
1. Products
2. Customers
3. Product_Type

Products is a list of all my products.

Customers is a table that shows the products that each customer has purchased

Product_type: because products can be more than one type

I want to find a list of all the products that I have of a certain type that customers have not purchased.

I have gotten help here before on creating a list of all the products that a customer has not purchased but not I want to define it more to the types of products a customer hasn't purchased:

Any ideas?

Options: ReplyQuote


Subject
Written By
Posted
multi table join question
February 12, 2007 11:57AM
February 16, 2007 09:10AM
April 09, 2007 06:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.