Citigroup Interview Question
AnalystsCountry: United States
Inner Join: Inner Join occurs between two relations when matching tuples are found and join together in a single tuple.
Left Outer Join: It is one type of Outer Join where, two relations R & S are combined regardless of matching tuples and all the fields of the left relation should be present in the combined relation and if any field is not found for the right relation fill this field with NULL value.
View: View is a Virtual Table in the database system. "CREATE VIEW view_name AS SELECT column 1, column 2 FROM table_name WHERE condition..... " --- by using this statement we create view....
One of the differences (in case of equi-joins) is that an inner join query retrieves only the common data whereas an outer join retrieves at least complete data set from one of the tables.
- Ashish June 19, 2012