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

please post your query. You will get cartesian product if you have less join conditions than your tables

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.