Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 13 Jan 2005 @ 17:43:45 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023