Database

Joins

Posted on January 15, 2008. Filed under: Database | Tags: inner join, left outer join, madhuri chopurala, Outer join, tables, union |

Joins allow database users to combine data from one table with data from one or more other tables (or views, or
synonyms). Tables are joined two at a time making a new table containing all possible combinations of rows from
the original two tables.
Inner joins: Chooses the join criteria using any column names that happen to match [...]