Archives of the TeradataForum
Message Posted: Thu, 13 Jan 2005 @ 17:43:45 GMT
| Subj: | | Re: Applying LEFT OUTER JOIN in the WHERE condition |
| |
| From: | | Coffing Christopher L |
You Wrote
| | Is there a way I can apply the LEFT OUTER JOINS in the WHERE condition as we do in Oracle. | |
Outer Joins are accomplished in the FROM section of your SQL statement and Inner Joins and residual criteria in the WHERE section.
Other than comfort levels using PL/SQL what are you trying to accomplish?
The resulting Outer Joins should provide the same result.
Perhaps you can trick an outer join in the WHERE section using a subquery but you are still bound by syntax when joining rows.
Chris Coffing
Air Force Knowledge Services (AFKS)
Lead DBA Operations & Support
Teradata Certified Master
| 
