![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Wed, 06 Apr 2005 @ 18:42:01 GMT
Subj: | | Re: Outer Join Syntax |
|
From: | | Jason.Fortenberry |
Bill,
I have seen that in Cognos when we try to apply a "filter" to outer joined objects. The tables may be related in the tool via an outer join,
but then Cognos would translate "filters" applied at runtime as only a WHERE clause and not an additional ON clause, as in your Desired SQL. I
don't know if Cognos ever agreed it was a bug, but we assigned it as such, and created a work around by either never applying "filters" to outer
joined objects or, most likely, by creating views in the DB that masked the outer join from the reporting tool. Cognos would then only look at
this view and no longer have to generate outer join SQL.
For us, it had nothing to do with Teradata, its ODBC driver, CLI, or anything on the DB side. It was simply the way Cognos interpreted filters
and generated SQL. I have not encountered that with any of the tools you mentioned, so I can't say if this is applicable to your situation :-(
Good luck,
Jason
| |