How to join in framework manager

[candy]

HI
How do we join Query Items in framework manager?
i know that we can join it by creating relation ship for both query items.
Suppose if we want to make inner join,right outer join,left outer join how can we do that?

Thanks
candy

[imts]

You can do that by selecting the different cardinality options provided with the relationships.
Relationships having 0 in them 0..n represents an outer join where as one with 1 Eg. 1..n represents an inner join.

Regards,
Tarun

[candy]

Hi Tarun

Thanks for you reply.How we can do right and left outer join?You mean we hav to change the cardinality in create relation ship window.or we need to change it in diagrams window.


Thanks
Candy

[imts]

Hi Tarun

Thanks for you reply.How we can do right and left outer join?You mean we hav to change the cardinality in create relation ship window.or we need to change it in diagrams window.


Thanks
Candy

Considering table(or Query Subject) A and another table( or Query Subject) B.
Depending upon the cardinality u select (0..n/1..n) u can see the join created (left/right) in the "Relationship SQL" tab of the "Relationship Definition" window.
And regarding the diagram thingie u asked, well u can change the cardinality either way i.e through the create relationship window or the diagram window.Both with impact the query in the same way.

Regards,
Tarun

[candy]

Hi Tarun

Thank u so much..............

[Arpit Agrawal]

You can also write a custom Expression while creating a join which can be usefull at times

[cognos_guru]

Arpit, any idea how to create an outer join from the join expression window?  I am in report studio and for some reason I can no longer get the join diagram window, only the expression editor.  I need to indicate any outer join from writing the join...