The Outer Join is an extension of the Inner Join which includes both rows that qualify for a simple Inner Join as well as a specified set of rows that do NOT match the join conditions mentioned in the query. This is the reason sometimes it gets a bit complicated to code the Outer Joins [...]
Archive for September, 2007
Inner Joins in Teradata.
As discussed previously, in Teradata we have the following types of Inner Joins. Ordinary Inner Join Cross Join Self-Join Let’s discuss how they are different from each other and how to use them. Ordinary Inner Join: – As you know, JOIN allows you to select common columns and rows from two or more tables/views, similarly [...]
More From Choose a category
Recently in Choose a category
Latest in Choose a category
Tags Cloud
Recent Comments
- admin on Arithmetic Functions and Operators in Teradata SQL.
- jampa on Arithmetic Functions and Operators in Teradata SQL.
- Rahul Kale on Transaction Management
- Ravi prakash on Usage of Macro in Teradata
- bhanwar on How To Choose A Good Online Traffic School
Archives
- March 2011 (1)
- March 2010 (1)
- December 2009 (1)
- December 2007 (1)
- November 2007 (1)
- October 2007 (16)
- September 2007 (3)
- August 2007 (21)
- July 2007 (17)
- June 2007 (15)
- May 2007 (8)
- April 2007 (4)



