Glossaria.net

Glossary Visual Basic / Term

self-join

self-join

A join in which records from a table are combined with other records from the same table when there are matching values in the joined fields. A self-join can be an inner join or an outer join. A self-join is useful when you ask hierarchical questions, such as a query that shows all the managers and the people who report to them.

Permanent link self-join - Creation date 2020-06-07


< select query Glossary / Visual Basic SelLength >