Thursday, 25 October 2012

Difference between Inner join and outer join? | Teradata Interview Questions

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.

No comments: