Join (SQL)
An SQL join clause combines records from two or more tables in a database. It creates a set that can be saved as a table or used as is. A JOIN is a means for combining fields from two tables by using values common to each. ANSI standard SQL specifies four types of JOIN: INNER, OUTER, LEFT, and RIGHT. As a special case, a table (base table, view, or joined table) can JOIN to itself in a self-join.
A programmer writes a JOIN predicate to identify the records for joining. If the evaluated predicate is true, the combined record is then produced in the expected format, a record set or a temporary table.
Read more about Join (SQL): Sample Tables, Inner Join, Outer Joins, Merge Rows, Alternatives, Implementation
Famous quotes containing the word join:
“Our ability to fall in love requires enough comfort with our masculinity to join it with someone’s femininity and feel enhanced. . . . If our mother made us feel secure and proud in our masculinity, then we want to find that again in our wife. If we are really comfortable with our mother, we can even marry a woman who is a friend rather than an adversary, and form a true partnership.”
—Frank Pittman (20th century)