Retrieving Data from 3 tables
Hi,
I want to retrieve data from 3 different tables.
The Table structure is as below:
PRODUCTS
--------
ID
NAME
CATEGORY
--------
CATEGORY_ID
NAME
CATEGORY_PRODUCTS
-----------------
CATEGORY_ID
PRODUCTS_ID
DESIGNER
--------
DESIGNER_ID
NAME
DESIGNER_PRODUCTS
-----------------
DESIGNER_ID
PRODUCTS_ID
I want to retrieve products that belong to a certain designer and also belong to a certain category. Basically, I have a filter on the website where the customer selects a designer first which displays all the products for that designer. Category filter allows the customer to futher filter the products by selecting a particular category and filter the products based on designer and category selected.
Hope I have explained properly.
Please help me to build this query.
Thanks
Subject
Written By
Posted
Retrieving Data from 3 tables
June 19, 2013 06:44PM
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.