JOIN (EN)

Concept

Operation for combining rows from two or more tables based on related columns

JOIN Types

flowchart TD     A[Table 1] -->|INNER JOIN| B[Result]     C[Table 2] -->|INNER JOIN| B     A -->|LEFT JOIN| D[Result]     C -->|LEFT JOIN| D     A -->|RIGHT JOIN| E[Result]     C -->|RIGHT JOIN| E     A -->|FULL OUTER JOIN| F[Result]     C -->|FULL OUTER JOIN| F

Example

Related to: SQL, Database normalization, Query language
Example use: Combining customer data with order data

Quelle: AI Generated