Archives of the TeradataForum
Message Posted: Thu, 13 Jan 2005 @ 17:43:45 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|