As of May 31, 2023, we have updated our Code of Conduct.
Database Administrators

About

Ask Question
Tag Info
Info Newest Frequent Score Active Unanswered

An SQL join clause combines records from two or more tables or views.

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 JOINs: 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.

History Excerpt history


Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.