SQL Query Join - Minor problem encounted

[keating101]

Hello All,

I am quite new to cognos report studio, so please bear with me.

I have a designed a report that lists all the transactions for a department centre. Some of the transactions are store issues from an internal warehouse. The only information I can get in this report is the product id number, not the actual description of the product.

So i have created an SQL join (joined by common link of product id number) to look up the product id description.

The sql join is working fine, and the product description is been shown correctly.

However, all the other transactions in the department (ie salary transactions) are now not been displayed ?

I hope this makes sense.

I would appreciate any one's feedback on how to overcome this problem.

thanks in advance
Shaun

[blom0344]

You may need to define a left outer to avoid losing data.  You can set this in the join definition  as  1--0  or  N--0  cardinality

[keating101]

Solution successful - thankyou