SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Join multiple tables(6 tables) without duplicates

861230May 11 2011 — edited May 11 2011

Hi guys,

I am having a problem with SQL query. I have 6 tables (Product,Manufacturer, ProductSpecs, GeneralSpecs, ProductConf, GeneralConf)

1. Product and Manufacturer are referenced with ManufacturerID
2. ProductSpecs and GeneralSpecs are referenced with SpecID
3. ProductConf and GeneralConf are referenced with ConfID
4. Product,ProductSpecs and ProductConf are referenced with Product_ID

My requirement is to get the list of a particular product for each manufacturer with the list of unique Product Specification and Product Configuration. I had joined all the tables using LEFT OUTER JOIN, but i am getting numerous duplicate records. I need an efficient query so that I get all the information without any duplicates.

Thanks in advance
Arun

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 8 2011

Added on May 11 2011

#performance, #query, #sql

2 comments

1,249 views