left outer join

[Cog8i]

Can we use the Left outer join in cognos8?

 

[almeids]

Of course, you can use it whenever you want.

 

[Cog8i]

Can you tell me that how to use Left outer join in cognos8(Report studio)?

 

[almeids]

You would need to model it in FM, I'm not sure that you could make it happen on the fly in RS if that's what you mean.

 

[almeids]

Addendum to my previous post...I should have added "unless you want to write your own SQL." Although I wouldn't personally recommend it, you can always bypass FM...

 

[Cog8i]

well...i'm working on a report in Report studio and i want to use the left outer join...
i'll really appriciate that if you could tell me that how can i use the left outer join...and what is the format...b/c its not accepting the SQL format

 

[almeids]

I'm not sure what to tell you...if you are coding your own sql in the report, you should be able to use whatever the native syntax is for your database. For example, in Oracle you can use the "left_table.column (+)= right_table.column" syntax (or the ANSI "LEFT OUTER JOIN" syntax in newer versions I think I read somewhere). Try copying the sql and running it directly against the database, if that works it should work in RS as well.

 

[awijasa]

If you want to do left outer join through CRN, the feature that is closest to it is Master/Detail Relationship.