Hi, i have query where i joined 4 tables and i am getting 3 records which is correct
but as soon as i joined 5th table records getting duplicated. i am getting 9 records now
can someone help me how can we eliminate duplicate records in multiple joins
all joins i am using is inner join
i am running query in oracle db but this should be same in sql db as well.
i referred some forums but that didn;t helped me much
any help is much appreciated.