I get duplicates on joining stored procedure based query to a normal query

[sameena]

Hi,
   I created a report by joining a stored procedure to a normal query. I have joined them using 1:1 relationship. But my output displays a couple of duplicates and a few rows are missing too. Please suggest..

Thanks,
Sameena

[blom0344]

Setting the cardinality to 1:1 has no effect whatever in production of the output. It is strictly a way for Cognos to determine a fact in the relation. The join strategy (database) determines whether duplates are returned. The missing rows may be the result of not using an outer join.
Determine which side is the master and apply outer join.

[sameena]

Thanks blom!! I used outer join and see no duplicates now.

Sameena