An SQL JOIN clause is used to combine rows from two or more tables, based on a common field between them. A JOIN is a means for combining fields from two tables (or more) by using values common to each.
ISO/ANSI standard SQL specifies seven types of JOIN:
- LEFT OUTER
- RIGHT OUTER
- FULL OUTER
See also A Visual Explanation of SQL Joins.
Specific join tags :
You can specify your question by adding extra tags:
left-join inner-join outer-join self-joincross-join full-outer-join right-join natural-join