1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

To avoid cartesian results while joining more than 10tables

Discussion in 'SQL PL/SQL' started by tiruvengat, Apr 16, 2009.

  1. tiruvengat

    tiruvengat Guest

    hi to all,

    In my oracle db im handling 15 tables and i have join all the
    tables all together by using relationships .When i try to fetch any one particular value in the where clause,
    the outcome of the result is cartesian.
    How to avoid the cartesian results and what steps to follow in oracle (Cond: all the tables should clubbed)?

    Thanks in advance
    cheers
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    please post your query. You will get cartesian product if you have less join conditions than your tables
     
  3. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    The reason could be,


    1. You missed some vital condition to add in the where clause to get rid of Cartesian result

    2. There is some duplication happens in nay one of the tables.