Inner Join
Overview
An inner join combines data from two or more schemas based on a common field, or a set of common fields between them. The result of an inner join contains only the rows where the specified fields have matching values in both schemas.
In other words, when you perform an inner join between two schemas, you're retrieving documents that have matching values in the specified fields of both schemas. Documents with non-matching values are excluded from the result.
Inner joins are often used to combine related data from different schemas, allowing you to query and analyze information in a meaningful way by connecting data points based on their relationships.
Example
Selects text from the Words schema and returns the associated language name from the Language schema.
SELECT
W.Text,
L.Name as Language
FROM
WordList:Words as W
INNER JOIN WordList:Language as L
ON L.Id = W.LanguageId
Related
- Keywords - A breakdown of all high-level statements available via the query handler.