What Is Inner Join And Outer Join?

1.	What Is Inner Join And Outer Join?
Answer» An INNER join gets data from both tables where the specified data exists in both tables. An OUTER join gets data from the SOURCE table at all times, and RETURNS data from the outer JOINED table ONLY if it matches the criteria. An inner join gets data from both tables where the specified data exists in both tables. An outer join gets data from the source table at all times, and returns data from the outer joined table ONLY if it matches the criteria.

Answer»

An INNER join gets data from both tables where the specified data exists in both tables. An OUTER join gets data from the SOURCE table at all times, and RETURNS data from the outer JOINED table ONLY if it matches the criteria.

An inner join gets data from both tables where the specified data exists in both tables. An outer join gets data from the source table at all times, and returns data from the outer joined table ONLY if it matches the criteria.

Discussion

No Comment Found

Related InterviewSolutions

What Are The Basic Rules That Define How Pi Is Defined In Teradata?
What Is A Common Data Source For The Central Enterprise Data Warehouse?
What Are The Enhanced Features In Teradata V2r5 And V2r6?
What Is An Optimization And Performance Tuning And How Does It Really Work In Practical Projects?
Teradata Performance Tuning And Optimization?
Can We Load A Multi Set Table Using Mload?
Can I Use "drop" Statement In The Utility "fload"?
In A Table Can We Use Primary Key In One Column And In Another Column Both Unique And Not Null Constrains.if Yes How?
What Are The Types Of Tables In Teradata ?
Can You Recover The Password Of A User In Teradata?

What Is Inner Join And Outer Join?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment